Posted journals import

Parent Previous Next

All files exported in the Posted journals option in the Export (Setup ribbon) cannot be imported as the TXF or XML file formats in TurboCASH5 (Build 913 and Build 969).

All other file types in the (Posted journals) option in the Export (Setup ribbon) cannot be imported as well using the Posted journals import option (F9:Process) option of the Journal entry screen.  

The following options is available:

Posted journals - Import a posted journal  option (F9:Process) of the Journal entry screen. You may select a posted journal on the Posted journals tab of the Journal entry screen to import.

Unposted journals - it is recommended that you use Write delimited file option (F9:Process) of the Journal entry screen. You need to re-enter the journal transactions from scratch. If you have large journal or may other journals to import, you may do the following:

oMake a copy of the Set of Books (Save as (Setup ribbon))

oUnpost (cancel) the journal in Tools Global processes Reverse posted journal/document menu (Setup ribbon).

oOpen the Journal entry screen and use the Write delimited file option (F9:Process) of the Journal entry screen. This will create a Comma Separated Value (*.csv) file.

oReopen the Books into which you need to import the unposted transactions.

oOpen the Journal entry screen and use the Delimited file import option (F9:Process) of the Journal entry screen. Select the Comma Separated file (*.csv) file. The journal transactions will be imported. Delete the balancing entries (********) and rebalance the journal.

It is important to check and edit the transactions imported in the journal, before you proceed to post the journal.

Created with the Personal Edition of HelpNDoc: Easy EPub and documentation editor