Trial Balance Export

In Sage One Accounting, you are able to export your trial balance to a .CSV file. This allows you to import the exported file into other .CSV compatible software.

You can also select to assign account numbers.

You access this function via the Accountant’s Area menu option.

Export without assigning account numbers

To export your trial balance, select your reporting period and viewing options.

Your date range options are:

Monthly Select this option if you want to run the trial balance for a selected month.
Yearly Select this option if you want the trial balance to include only a year’s transactions.
Life to Date Select this option if you want the trial balance to include all transactions from the start of the business.
This Year Select this option if you want the trial balance to include only the current financial year’s transactions.
Last Year Select this option if you want the trial balance to include only the previous financial year’s transactions.

Your viewing options are:

Options Explanation Calculation
Closing Balances Select this option if you want the trial balance to display account closing balances, including transactions from the beginning of the year up to the end of the selected month. Closing Balances = Opening Balances + any debit and credit transactions (per account) from the beginning of the year up to the selected month
Movements Select this option if you want the trial balance to only display accounts which had transactional activity for the selected date range. This will not include the opening balances of the accounts. Movements = Debit and Credit Transactions (per account)

After you have made your selection, click on the Export Data button. A File Download screen displays, allowing you to Open, Save or Cancel the exported “TrialBalance.csv” file.

Click on the Open button to view the exported Trial Balance, click on the Save button to save the file or click on the Cancel button if you do not want to continue with the export process.

The exported .CSV file contains, by default, the following column headings:

  • Account Code
  • Account Name
  • Date
  • Debit
  • Credit

The date that filters through to the .CSV file, is the last day of the selected date range.

If you wish to display your reporting group detail in the report, check the check box.

Export and assign account numbers

To export your trial balance and assign account numbers to the list of accounts, complete the screen by selecting your date range and viewing options.

Click on the Assign Account Numbers button.

The following screen displays:

Assign account numbers in the Account Number column by manually typing in a alphanumeric and/or numeric number.

You do not have to assign account numbers to all of the accounts.

These assigned account numbers will be saved for future exports.

Click on the Save button to save your account numbers and the system will return to the Export Trial Balance screen.

Click on the Export button to export your trial balance.