The importance of an accurate opening balance with an example

Before starting with Bookkeep financial data sync, it is important that your books have an accurate opening balance

Opening balances represent the financial position of your company on the day before you start using Bookkeep. Without accurate opening balances, reports cannot give you a true picture of your financial position. Opening balances are important because they ensure the accounts are accurate and help to keep historic accounting records. 

We recommend that you start using Bookkeep at the beginning of a new accounting period, whether this is a new month or quarter, or the start of your fiscal year. You can then produce your final trial balance from your prior period. This ensures that all of the values you enter are accurate and have been reconciled.

In the simplest of terms, a company’s opening balance refers to the funds in its account at the start of a new financial period. In other words, the closing balances of the previous accounting period become the opening of the new accounting period. For a newly formed limited company, there will be no opening balance as there were no prior year end accounts. The closing balance for an accounting period is the sum of the differences between all of the credits and debits experienced by a business over that period. This amount is then carried over to the next accounting period to be used as the opening balance.

Before starting with Bookkeep, ensure an accurate opening balance by reconciling all bank and balance accounts (e.g. Stripe or Shopify balance/clearing accounts where you may have a pending balance from prior sales not transferred to your bank account). It is important to ensure that the opening balance matches the bank statement, POS system or ecommerce app. Any discrepancies should be investigated and resolved promptly. 

Example:

Let’s take the example of My Ecommerce Store. My Ecommerce Store set up an online business on Shopify using Shopify and PayPal to process payments. My Ecommerce Store was manually recording sales and deposits each month due to limited time to record them daily. However, after discovering Bookkeep, My Ecommerce Store began using Bookkeep on 11/1/2023 to automate syncing of financial data from Shopify and PayPal into QuickBooks.

October 31, 2023 closing balances became the opening balances on 11/1/2023 when using Bookkeep. As a result of this start with Bookkeep, it was important that all sales and payments up to 10/31/2023 were fully recorded in QuickBooks prior to starting Bookkeep. 

This migration resulted in sales of $1,000 on 10/31/23 being recorded manually in QuickBooks prior to Bookkeep with a running balance in the PayPal clearing or balance account of $300 and a running balance in the Shopify clearing or balance account of $700 from the 10/31/23 sales. This allowed Bookkeep to then begin recording sales and deposits on 11/1/23 for My Ecommerce Store. Additionally, the PayPal and Shopify deposits automated by Bookkeep captured the $300 and $700 transfers to the company's bank account on 11/2/23. By having accurate opening balances when starting with Bookkeep, My Ecommerce Store was able to seamlessly capture expected transfers from the balance accounts to the bank account with accurate opening balances.

If you have any questions, please contact support@bookkeep.com.