Manager Starting Balances - BC Bookkeeping Tutorials|dwmbeancounter.com

Title
Go to content

Manager Starting Balances

Starting Balances > Starting Balances Explained
Starting Balances

Starting balances are used only when migrating accounting for an entity to Manager from a prior accounting system. They can be set only for balance sheet accounts or, when appropriate, for their subsidiary ledgers. (See information below.) They are not used for new businesses just beginning operation. Starting balances on the date you begin using Manager should equal ending balances for equivalent accounts in the old accounting system.

Notes
Versions of Manager prior to 21.8.41 included various schemes for entering starting balances that required establishing a defined start date in the Settings tab. The prior requirement for a defined start date no longer exists. As used in Guides, start date refers to the date you begin recording your day-to-day transactions in Manager. As described below, certain transactions from before the start date may still be entered; but, those should all be transactions that were also entered in your prior accounting system.

Starting balances are only set for accounts on the balance sheet, not the profit and loss statement, because balances of accounts on the profit and loss statement depend only on transactions during the current financial period. In other words, starting balances are only entered for asset, liability, and equity accounts.

The starting balance of the Retained earnings account is determined automatically by the program as other starting balances are entered. This ensures the accounting equation (Assets = Liabilities + Equity) is always in balance. If the starting balance of Retained earnings in Manager does not match the closing balance of your prior accounting system after all other starting balances are entered, you have one or both of two problems. Either (1) you have entered another starting balance incorrectly in Manager or (2) your prior accounting system balance sheet was out of balance. Identify and correct the source problem. Do not attempt any adjustment to the Retained earnings account, as that is not possible.

Starting balances are entered in one of three ways, depending on whether they pertain to:
  • Ordinary accounts
  • Subsidiary ledgers of control accounts
  • Pending invoices and bank transactions

Manager allows only one method for any account, subsidiary ledger, or transaction, so you cannot choose incorrectly.

Starting balances for ordinary accounts
An ordinary account is one you add yourself in the Settings tab, from the Chart of Accounts page:
Ordinary accounts do not include those added automatically by Manager when certain functional tabs are created. Nor do they include control accounts created from the Control Accounts page in Settings. For accounts with an Edit button next to their names in the chart of accounts, click the button. If they are ordinary accounts, a Starting balance field will be available:
Select whether the starting balance is a debit or credit from the dropdown list, enter the balance (always as a positive number), and click Update.

Note
Starting balances for asset accounts are normally debits, unless the account is a contra asset account (one where the balance is usually negative). Starting balances for liability accounts are usually credits, unless the account is a contra liability account. Starting balances for equity accounts are credits when the business owes money and debits when the business is owed money.

Example
Sample Consulting, a sole trader, switches its accounting to Manager at the beginning of the calendar year. On the day it begins using Manager, Sample Consulting has a liability in its Tax payable account for taxes collected from customers but not yet paid to the tax authority. So it enters a starting balance credit by editing the Tax payable account in Chart of Accounts under the Settings tab:

Note
If you don't setup a Tax Payable account in the chart of accounts a default account is automtically enabled. The beginning balance of this account is determined from the sales tax amounts entered on the unpaid sales invoices using the cash basis of accounting.

If using accrual a Tax payable account needs to be setup in the Chart Of Accounts and the tax code(s) setup and assigned (Settings-tax codes) where you can enter a beginning balance.
Starting balances for subsidiary ledgers

Subsidiary ledgers can be thought of as subaccounts of control accounts. Control accounts may be activated automatically when certain functional tabs are enabled. They may also be custom control accounts you define on the Control Accounts page in the Settings tab. They include:
  • Accounts receivable and Accounts payable
  • Cash at bank and Cash on hand
  • Fixed assets, at cost and Intangible assets, at cost
  • Inventory on hand
  • Employee clearing account
  • Capital accounts
  • Custom control accounts

Starting balances are not set directly for control accounts of any type. Instead, they must be set for individual subsidiary ledgers (subaccounts). To set a starting balance for a subsidiary ledger, go to the tab used for defining that type of subaccount. Default relationships are:
  • Bank and Cash Accounts for Cash at bank and Cash on hand
  • Customers - Sales Invoices for Accounts receivable
  • Suppliers - Purchase Invoices for Accounts payable
  • Inventory Items for Inventory on hand
  • Employees for Employee clearing account
  • Fixed Assets for Fixed assets, at cost and Fixed assets, accumulated depreciation
  • Intangible Assets for Intangible assets, at cost and Intangible assets, accumulated amortization
  • Capital Accounts for Capital accounts
  • Special Accounts for special accounts assigned to any custom control account

Note
If control account assignments for subsidiary ledgers have been changed from the defaults above, starting balances are still set in the default tabs listed. Once you are in the tab where the subsidiary ledger or subaccount is defined, click Edit for that ledger and enter the starting balance.

Example
Sample Consulting has one fixed asset, its office computer. So two companion accounts are included on its balance sheet, Fixed assets, at cost and Fixed assets, accumulated depreciation. On the start date, the fixed asset purchase was already completed, and the asset was partially depreciated. After defining the office computer as a fixed asset in the Fixed Assets tab, Sample Consulting enters the acquisition cost and accumulated depreciation from its prior accounting system:
After Update is clicked, all three modified accounts from the two Examples show their correct starting balances on the Summary page:
Starting balances for pending invoices and bank transactions

The final category of starting balances requires additional steps. A simple, summary balance at the subsidiary ledger level would not be sufficient, because future transactions or events may be linked to ones from before you began using Manager. Therefore, the prior transactions themselves must be entered, with transaction dates before your Manager start date. Such transactions include:
  • Unpaid sales and purchase invoices
  • Pending bank transactions

Unpaid invoices
Sales and purchase invoices not fully paid (accounts receivable and accounts payable) as of your start date are entered exactly like normal invoices, but with dates before your start date. If an invoice has been partially paid, only its remaining balance due is entered. Manager uses these pre-start invoices to establish starting balances for Accounts receivable and Accounts payable. Because you will initially set your reporting period to begin on your start date, pre-start invoices will not affect your income or expense accounts. During later reporting periods, they will also be similarly ignored.

    

Carefully consider inventory items on pre-start invoices. If items on a sales invoice were already delivered under the prior accounting system, add the quantities back to the starting balances for those inventory items, because the pre-start sales invoice tells Manager they are being delivered again.

Likewise, if items on a purchase invoice were already received under the prior accounting system, subtract them from starting balances for those inventory items, because the pre-start purchase invoice tells Manager they must be received again.

Comment
This in my opinion can be a time consuming process requiring you to summarize all the unpaid inventory items on all your unpaid invoices. If I'm not mistaken, this requirement resulted from Manager providing a cash and accrual basis of accounting and was necessary so that the cash basis results are correct. For those using the accrual basis consider using my Quick Starting Balances Setup Instructions.

If you will be using delivery notes or goods receipts to track quantities of the items involved, be sure to also enter those transactions. (Dates can match actual delivery or receipt dates, even if they are pre-start.) Your goal in adjusting starting balances for inventory items is to leave only the receivable or payable aspect of an invoice outstanding.

Example
On its start date, Sample Consulting has an overdue sales invoice issued to Brilliant Industries last year. It enters the invoice using the process described.The Accounts receivable control account reflects the change to the starting balance. But the Sales income account to which the invoice was posted shows nothing for the current period:
Note
More information about starting balances for customers is here. More information on suppliers is here.

Starting Balances for Bank Accounts and pending bank transactions

Beginning Bank and Cash Account Balances
Beginning bank account balances are entered using the Bank and Cash Accounts Tab. If you're not tracking pending transactions enter the book balances from your prior accounting records. This balance should include any pending transactions.

See Bank and Cash Accounts for additional information.
Pending bank transactions are entered in the Receipts and Payments tabs, using dates before your start date. The Status field must be set to Pending. As with pre-start invoices, deposits and withdrawals themselves will not affect income or expense accounts, because the transactions will be dated before the beginning of your reporting period.

However, starting balances for bank accounts must be adjusted upwards or downwards to compensate for the pre-start receipts and payments you enter. Confirmation that your starting balances for bank accounts are correct occurs when Cleared balance, Pending deposits, Pending withdrawals, and Actual balance in the Bank and Cash Accounts tab match the actual status of your accounts on your start date. (A successful bank reconciliation will also be possible at this point.)

Example
Just before it started using Manager, Sample Consulting received and deposited into its bank money for a sales invoice. The sales invoice was considered paid in full in the old accounting system, so it was not entered as a starting balance in the customer’s subsidiary ledger under Accounts receivable. But the starting balance of the bank account only included cleared amounts of 4,679. So the receipt was entered with its original deposit date. Status was set to Pending. The Bank Accounts tab accurately reflects the complete status of the bank account:
Comment
I recommend ignoring pending transactions and just enter your actual book cash balances that assume all pending transactions have cleared.
Back to content