Choosing a starting balance (BS/CF)

When you are using our Balance Sheet and Cash Flow feature, you'll need to import a starting balance so that you see the correct data, but what date should this balance come from?

There are two considerations here:

  1. How far back to do you want to be able to review your actual data?
  2. How far back is your chart of accounts in the same format?

If you've made structural changes to your COA, or some of your older data is not as clean as you'd like, then you should choose a date after that point, and if you only need to see the last two years of actual data, then maybe use the trial balance from the end of the previous fiscal year.

Once the trial balance from your starting point has been imported, every import of actual data subsequent to that date will update the deltas and adjust the balance sheet balances accordingly.

When importing actual data you won't need to check the Run Double Entry box as all the balances will already be available in the imported data.