Upload journals

Once journals have been created, you can upload a selected range of journals to your client accounting system. How this works depends on your accounting system.

For Xero API or Reckon One users, journals are uploaded directly to your online accounting software. For other system types, a CSV file is created and saved to the file path selected on the setup sheet.

How to upload journals

  1. Check the variance indicator at the top of the sheet is nil (a – (dash) is displayed).
  2. On the CCH Workpapers ribbon, click the Upload Journal button.
  3. Select one of these options:
    1. To upload all journals, select the All check box.
    2. To upload journals within a specific range, select the Journals check box and select the range.
  4. Ensure the correct CSV file path is displayed in the dialogue box (this should be automatically updated from the Admin Setup sheet). This step is not applicable to Xero API or Reckon One users.
  5. If your journals are to be autoreversing see steps below.
  6. Click OK.

Create auto reversing journals

The following steps apply for MYOB AO and APS XPA users only. For all other system types, set the batch of journals to be autorerversing within your accounting system.

  1. Check the variance indicator at the top of the sheet is nil (a – (dash) is displayed).
  2. On the CCH Workpapers ribbon, click the Upload Journal button.
  3. Select one of these options:
    1. To upload all journals, select the All check box.
    2. To upload journals within a specific range, select the Journals check box and select the range.

  4. Select the Creating reversing journals? check box,

    1. For APS users,

      • An extra column is added to the standard journal CSV file, indicating that the journals are to be auto reversing

    2. For MYOB AO users:

      • Ensure correct reversing CSV file path is displayed in the dialogue box as a seperate CSV file is generated for reversing journals.
      • Exported reversing journals are dated the 1st of the next financial year and should be imported at the begining of the next financial year.
  5. Click OK.

Upload the journals into accounting software

Depending on your client accounting software, different instructions apply to upload journal entries.

  1. In iFirm, open the client’s general ledger.
  2. Click Import > Import transactions.
  3. Click Add+.
  4. Select your CSV journal file and click Open.
  5. Click Import Transactions.
  1. Open client’s general ledger file.
  2. Click Data entry > Transaction import.
  3. Click on the Import tab.
  4. Browse to the folder where the CSV files are saved and select the appropriate CSV file.
  5. Select Post all entries, if you want to auto post the journals
  6. Click Import.
  1. Open the client’s general ledger file.
  2. Click File > Import > Other cashbooks.
  3. Select the top option MYOB specified format and click Next.
  4. Browse to the folder where the CSV files are savedand select the appropriate CSV file.
  5. Click Next.
  6. Click Finish.
  1. Open the client and go to the Client Accounting > Trial Balance (Workpapers) tab.

  2. On the Tasks bar, click Manage client file imports.

  3. Select .CSV

  4. Click the … button and select the journal CSV file.

  5. Select your template: choose Default Template (unless you have created a custom template).

  6. Click Next

  7. Select your mapping options – the first option does not apply as the chart of accounts used by the workpapers is the same as the ledger.

  8. Click Next

  9. Click Finish

  1. In MAS job, click Utilities > Import > Third Party Transactions.
  2. Select I have back up of ledger.
  3. Browse to the folder where the CSV files are savedand select the appropriate CSV file.
  4. Click Next and leave as delimited, comma.
  5. Click Next and select No mapping.
  6. Click Next > Import.

Journals are posted directly from the workpapers. In Reckon One navigate to Day to day > Journals to view.

The Xero integration process has changed. View our new help file.

  1. Navigate to Adviser > Manual journals.
  2. Click Import.
  3. Browse to the folder where the CSV files are savedand select the appropriate CSV file.
  4. Click Import.
  5. In Drafts, open Imported journals.
  6. Click Post.