Account Reconciliations
Ageing the reconciling items is the whole discipline: a difference that has been there for eleven months is not a timing difference.
Where to find it
- Module: Accounting
- Group: Close & Compliance
- Section: Financial Controls
- Screen: Account Reconciliations
Address in the console: /accounting/account-reconciliations
Read-only list · 15 columns · 3 actions
This list is read-only: its records are written by the work that produces them. A correction, where one is possible at all, is made where the record was created.
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| Document | Code | recon_no |
| Period | Code | period_code |
| Account | Code | account_no |
| Name | Text | account_name |
| Ledger | Amount | gl_balance |
| Supporting | Amount | supporting_balance |
| Difference | Amount | difference |
| Unexplained | Amount | unexplained_amount |
| Out of tolerance | Yes or no | out_of_tolerance |
| Oldest item | Number | oldest_open_item_days |
| Prepared by | Text | prepared_by_name |
| Reviewed by | Text | reviewed_by_name |
| Self-reviewed | Yes or no | self_reviewed |
| Overdue | Yes or no | is_overdue |
| Status | Status | status |
What you can do here
Generate for a period primary
Opens one for every account with a policy. Generating them is the only cure for remembering them.
Asks for: Period (YYYY-MM)*
Prepare primary
Pulls both balances from wherever the policy says, and ages the difference.
Asks for: Supporting balance (blank = derive it)
Review
Refused to the person who prepared it — the same failure as a self-approved journal, in a quieter place.
Asks for: Approve Comment
* required
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.