Updating the Client's records

You've made all the necessary adjustments in Checkmybooks and exported the Trial Balance to import into accounts production. Now it's time to import the adjustments back into the client's system so all the numbers agree.

Finalise the job

finalise

To complete the job click the Finalise button. You can always Unfinalise a job if you need to make further adjustments.

Additional fields for name and email addresses etc. may display when sending to client.

Additional fields for name and email addresses etc. may display when sending to client.

You can then choose to send yourself and / or the client a copy of the Report to Client and Adjustments. You'll receive a separate email for each, and the report or adjustments file will be included as an attachment.

 

Adjustment files will be in a format suitable for the client's software. Save the email attachment to a location on your computer you'll remember. For Sage, CSV files are used, and for Quickbooks it's an IIF file. Neither should be opened prior to importing.


Importing into Sage

You'll actually receive two CSV files for importing into Sage. You won't need to import both but make sure you pick the right one.

The Adjustments.csv file is for importing into Sage if the year end just reviewed in Checkmybooks is still "open". This means the year end routine has not yet been completed and ledger year end journals have not been posted.

If the year end routine has been run for the year reviewed using Checkmybooks then import the AdjustmentsAlternative.csv.

sage import.png

Open Sage with the client's data restored. Click the File menu and choose the Import option. The Sage import wizard will open to step you through the rest of the process.

We strongly recommend that you take a backup of the Sage file at Step 1 of this process.

Steps 2 and 3 are the only ones where any selections need to be made.

At step 4 you do not need to make any changes to the import mappings and can just click next to confirm the mappings presented.

You can check the adjustments and balances are correct in Sage but that's all there is to it.


Importing into Quickbooks

Open Quickbooks with the client's data restored. Click File > Utilities > Import > IIF Files

qb-import

Navigate to the file location on your computer and choose the IIF.

That's it. You should see a box appear indicating the file import is complete.