Setup Guide: Entering Opening Balances
If you are setting up a new business, setting up your accounting system is very easy. New businesses typically begin with zero balances in all financial accounts. Balances are generated by the entry of transactions in Sage 50 Accounting, such as a bill payment, or a sale.
If you have an existing business, and are converting from either a manual system or another accounting system, you will have account balances and existing record information that you must enter in Sage 50 Accounting to bring your new accounting system up to date.
Note: When you create your company in Sage 50 Accounting, you will be in history mode. In this mode, you can enter opening balances for accounts in your Chart of Accounts, customers, vendors, employees and payroll, and inventory. The Setup Guide can help you enter opening balances for accounts, customers, and vendors.
Beginning balances must be entered for each account, including bank accounts, credit card payables, and equity accounts.
If you have an existing system, print the Trial Balance report as of your conversion date and use it to enter your opening account balances in Sage 50 Accounting. If you are converting from a manual system, or your records are not as well organized as you'd like, consult your accountant for assistance.
Tips: If you are starting out in Sage 50 Accounting at the beginning of your company's fiscal year, all income and expense account balances will be zero.
If you work with foreign currencies and have set up your currency options in Sage 50 Accounting, you will be able to enter foreign account balances and exchange rates.
In every accounting transaction, total debits must equal total credits. When you enter an opening balance for an account, you are entering only half of the transaction - the debit or the credit. For example, if you received a bank loan of $ 25,000 to start your business, you would enter an opening balance of $ 25,000.00 in your Bank account (as a debit, or increase in an asset). To balance your books, you would enter an equal amount in your Bank Loans Payable account (as a credit, or increase in a liability).
When you enter opening balances in Sage 50 Accounting, the total amount of your debits should equal the total amount of your credits. If they don't, Sage 50 Accounting enters or posts the difference between the two to the Retained Earnings account.
Tip: If you have an existing business, you may already have an opening balance in your Retained Earnings account, so you should review this account's balance after you have finished entering opening balances for all your accounts.
As you set up your existing customer list in Sage 50 Accounting, you specify how much each customer owes you.
Vendor list setup is the same. When you set up your vendors, you specify what you owe each vendor. For example, if you tell Sage 50 Accounting that you owe Vendor ABC $ 100.00, then Sage 50 Accounting knows that this $ 100.00 balance represents an account payable.
If you enter opening customer and vendor balances in the Setup Guide, Sage 50 Accounting can automatically calculate and update your:
- Accounts Payable opening account balance, by summing the amounts you owe all your vendors
- Accounts Receivable opening account balance, by summing up the amounts all customers owe you
Note: By default the amounts are calculated according to the latest transaction date. If you wish to display amounts by session date, you need to turn on the Session Date option in the User Preferences.