Importing a Sage Trial Balance

[Glenn]

The Trial Balance report shows the total value of all of your credit and debit entries, and because your software controls the double-entry accounting entries for you, these values should always balance. Here we'll explain briefly how you can get a copy of your Trial Balance from Sage 50 Professional ready for import into QuickFile.

1. Log onto your Sage software.
   

2. Go to the ‘Reports’ tab on the tool bar and select ‘Financials’ from the drop down list .
   

3. From the ‘Financials’ drop down list select ‘Trial Balance’.
   

4. In the ‘Trial Balance - Modify Report’ window, in the boxes provided, simply select the end month you want to run the trial up to, this should be set to the month before you decided to start using QuickFile as described in our Opening Balances guide, in our example this would be set to March.
   

   

5. To generate your Trial Balance report, click ‘OK’.

6. Have a look over the Trial Balance to make sure everything is in order.
   

GENERATING THE CSV FILE:

7. Click the ‘Export’ tab in the tool bar.
   

   

8. Select CSV from the ‘save as type’ options and save the file to your desktop or a location you will remember later.
   

   

Once completed go back to the Opening Balances guide Step 3 to complete the import into QuickFile.