Opening Balance Check
Compares each customer's or supplier's opening balance with what is still open on that party's old documents, the ones dated before your go-live date. Use it after you move to Bizconnekt, to make sure the opening balances you entered agree with the old invoices and bills you brought in. It only shows gaps; it never changes a balance. It is on the web only.
Quick look
- Go to Reports › Business Reports and click the Opening balance check card.
- Choose Customers or Suppliers under Parties.
- Tick Mismatches only.
- Click Fix opening balance on a row to correct that party.
Done. You see every party whose opening balance does not match its old documents.
Full guide
What it shows, and when to use it
For customers, the opening balance must equal what is still open on the old invoices, credit notes and receipts. For suppliers, on the old bills, debit notes and payments. A negative amount on the customer side means you owe the customer; on the supplier side it means the supplier owes you. For how old documents work, see Entering documents from before go-live.
Filters
Fields in this section
| Field | Required | What to enter |
|---|---|---|
| Parties | No | Customers or Suppliers. Customers is chosen when you open the page. |
| Mismatches only | No | Tick to hide the parties that match. |
Tags above the table show Showing: suppliers and Mismatches only when they are on. There is no date filter: the check is as at your go-live date. If no go-live date is set, the page says there is nothing to check yet, and your admin sets the date in Settings → Configuration → Finance → Accounting Period.
Columns and tiles
Three tiles sit above the table: Parties (how many are checked), Mismatches and Go-live date.
Fields in this section
| Column | What it shows |
|---|---|
| Party | The customer or supplier. A warning appears under the name if the opening is dated on a day other than go-live. |
| Opening balance | The balance you entered. "No opening balance" if the party has none. |
| Open on old documents | What is still open on the party's old documents. |
| Difference | The opening balance less what is open on the old documents. A missing opening counts as zero. |
| Documents | How many old documents the party has. |
| Status | Matches or Mismatch. |
| Action | Fix opening balance opens that party so you can correct it. |
Under the tiles, See old documents links to the old invoices, credit notes and receipts (or bills, debit notes and payments) lists. When everything matches the page says "All n parties match." On the supplier side a Pending Inward card compares the Pending Inward opening with old bills whose goods are not yet received; if it does not match, it says to enter the goods billed but not received as a journal dated on go-live. A note lists any old documents that could not be read and are therefore not counted.
Sorting, drill-down and export
The columns do not sort and there is no column chooser, pager, export, print or email. The links in Action and See old documents are the only drill-down.
Who can see it
Open the page with View on Business Reports. Without it you see a No Access page. If you cannot use the business unit you are in, the page says you do not have access to it. Business Reports has only View and Add/Edit, and the check changes nothing. Correcting an opening balance from Fix opening balance needs access to the party.
On mobile
Web only. The mobile app does not list this check. Same on iPhone and Android.
The Android app is on Google Play. The iPhone app is coming soon to the App Store.
Problems and fixes
The page says there is nothing to check
No go-live date is set for your business unit. Ask your admin to set it in Settings → Configuration → Finance → Accounting Period.
A party shows Mismatch
Open its old documents from See old documents and compare them with the opening balance, then use Fix opening balance. The check never changes the balance for you.
A document is not counted
If the page says some old documents could not be read, open the note to see which ones and why. They are not in the figures until they are corrected.
The page says No Access
Your role does not have View on Business Reports. Ask an administrator to turn it on.