Appearance
Account Balances
Account balances show the financial position of each GL account over time. Finance users rely on them for trial balance review, account analysis, sub-ledger reconciliation, and financial statements.
Workspace Reference
| Workspace | How Users Reach It | What Users Usually Do There |
|---|---|---|
| Account Balances | Accounting -> Operations -> Financial Reports or account analysis views where available | Review opening balances, movement, closing balances, and sub-ledger support. |
| GL Journals | Accounting -> Operations -> GL Journals | Drill into journal entries behind a balance. |
| GL Reconciliation | Accounting -> Operations -> GL Reconciliation | Compare control accounts to supporting records and resolve differences. |
| Financial Statement Builder And Reports | Accounting and Reporting workspaces | Use account balances in statements, management reports, and close review. |
What Account Balances Answer
Use account balances to answer questions such as:
- What was the cash, receivable, payable, income, or expense balance on a specific date?
- What movement happened during the selected period?
- Does the trial balance balance?
- Do control accounts agree with their supporting sub-ledgers?
- Which business unit, currency, branch, or service is carrying the balance?
Balance Views
Pinkapple presents balances at several levels:
| View | What It Shows | Typical Use |
|---|---|---|
| GL Account Balance | Opening balance, debit movement, credit movement, and closing balance for an account. | Trial balance, account analysis, statement preparation. |
| Sub-Ledger Balance | Supporting balances beneath a control account, such as a customer, supplier, loan, deposit, wallet, till, or other tracked party/account. | Reconciling receivables, payables, loans, deposits, wallets, and cash controls. |
| Business Unit Balance | Balances filtered or grouped by branch, service, or operating unit. | Branch reporting and management review. |
| Consolidated Balance | Combined balances across selected units, after any required eliminations. | Group-level financial reporting. |
How To Read A Balance
Most balance views use the same core columns:
| Column | Meaning |
|---|---|
| Opening Balance | Balance at the start of the selected period. |
| Debits | Total debit movement during the period. |
| Credits | Total credit movement during the period. |
| Closing Balance | Balance at the end of the selected period. |
| Currency | Currency used for the balance. Multi-currency reports may show both transaction and reporting currency views. |
| Business Unit | Branch, service, or unit the balance belongs to. |
For asset and expense accounts, debit balances are normally expected. For liability, equity, and income accounts, credit balances are normally expected. An unexpected sign does not always mean an error, but it should be reviewed.
Trial Balance
The Trial Balance summarizes account balances for a date or period.
Use it to confirm:
- total debits equal total credits
- opening balances are reasonable
- period movements match expected activity
- unusual or suspense balances are investigated before close
- branch or service filters are producing the expected totals
If the trial balance does not balance, review unposted batches, failed posting attempts, incomplete journals, and period-close readiness feedback.
General Ledger Account Analysis
General Ledger analysis shows the transactions behind an account balance.
Use it when:
- a balance looks too high or too low
- an auditor asks for movement detail
- finance needs to trace a posting to its source transaction
- a period-close blocker points to a specific account
- a correction or reversal needs supporting evidence
Account analysis should include journal date, reference, narration, debit, credit, running balance, user or process, and any supporting business context available from the source transaction.
Sub-Ledger Reconciliation
Some accounts are control accounts. They summarize detailed balances held underneath them.
Examples include:
- customer receivables
- supplier payables
- loan accounts
- deposit accounts
- tenant wallets
- bank accounts
- teller tills and cash drawers
For these accounts, the control account balance should agree with the total of the supporting sub-ledger balances.
If they do not agree, investigate:
- journal lines posted directly to the control account without supporting detail
- missing or incorrect sub-ledger selection
- failed source-transaction posting updates
- backdated corrections posted to only one side of the relationship
- migrated balances that were not loaded consistently
Balance Sheet And Income Statement
Financial statements use account balances differently:
| Statement | Balance Treatment |
|---|---|
| Balance Sheet | Shows point-in-time balances for assets, liabilities, and equity. |
| Income Statement | Shows revenue and expense movement for the reporting period. |
| Cash Flow | Uses cash movements and classification rules to explain sources and uses of cash. |
For accrual accounting, income can appear before cash is received. For cash-basis reporting, users should use a report or product policy designed for cash recognition rather than assuming receivable movement is the same as revenue.
Period Close Impact
During month-end and year-end review, balances are used to confirm:
- all expected journals are posted
- all temporary suspense accounts are cleared or explained
- control accounts agree with sub-ledgers
- foreign currency balances are revalued where required
- profit or loss is ready for reporting or year-end transfer
Do not close a period while unexplained balance differences remain.
Common Issues
| Issue | Likely Cause | What To Check |
|---|---|---|
| Balance looks wrong | Missing journal, reversal, or backdated entry. | Account analysis and posting date filters. |
| Control account does not match sub-ledgers | Missing supporting ledger detail or direct control-account posting. | Sub-ledger reconciliation and source transaction context. |
| Income appears before cash is received | Product or posting policy uses accrual recognition. | Product accounting method and reporting basis. |
| Branch totals differ from expected totals | Wrong business unit filter or posting context. | Business unit, service, and journal date filters. |
| Foreign currency balance changed at close | Period-end revaluation posted gain or loss. | Exchange rates and revaluation batch. |
