Sage Bookkeeping Checklist
Follow this Sage bookkeeping checklist to improve reconciliations, coding, ledger control, VAT support, and month-end discipline in your SME.
- Sage bookkeeping should be reviewed monthly, not only when the year-end team asks questions.
- The checklist should test reconciliations, coding discipline, open items, and supporting records.
- Old unresolved balances are a sign of process drift, not a normal part of the file.
- A controlled Sage file should make VAT, accounting, and month-end review easier.
Sage bookkeeping checklist becomes expensive when the business only notices the weakness under deadline pressure. In South Africa that usually means a problem with system setup, human review, and the monthly checks that software cannot do on its own shows up just as Sage questions, management decisions, or month-end sign-off need a clean answer.
Sage bookkeeping works best when the monthly review process is stronger than the assumptions around it.
That is the reason for this checklist. It helps a business review whether the Sage file is genuinely under control or simply active.
The four areas every Sage review should cover
1. Reconciliation status
Bank accounts, supplier positions, customer balances, and control accounts should be current enough that management can explain them without delay.
2. Coding discipline
Repeated items should be treated consistently. If similar transactions are going to different places every month, the reporting quality will drift.
3. Open-item control
Old unresolved balances should be visible and owned, not silently carried forward.
4. Month-end readiness
The file should be strong enough to support VAT, accounting handoff, and management review without another round of hidden cleanup.
A practical Sage review table
| Area | What to ask |
|---|---|
| Bank accounts | Is the last reconciled month clearly confirmed? |
| Suppliers | Do the balances still make commercial sense? |
| Customers | Are receipts and allocations current and explainable? |
| Control accounts | Are VAT and key clearing balances supported? |
| Coding | Are recurring transactions being handled consistently? |
| Documents | Can unusual items be traced to source support? |
If those answers are weak, the bookkeeping process needs attention even if the file looks busy.
The monthly reconciliation checklist
Review these items every month:
- bank reconciliation complete
- old unreconciled items investigated
- supplier balances reviewed
- customer receipts allocated clearly
- suspense or clearing balances explained
These five checks alone prevent a large share of Sage drift.
The ledger-quality checklist
Look specifically for:
- duplicate supplier or customer records
- vague account names used too often
- old balances no one remembers
- repeated journals posted without explanation
- director or owner transactions treated inconsistently
Those are the habits that weaken trust in the file.
The support-document checklist
Ask whether the file is backed by usable support.
| Support area | Expected standard |
|---|---|
| Major supplier invoices | Easy to trace |
| Expense support | Stored and reviewable |
| Bank explanations | Clear for unusual transfers |
| VAT support | Available before deadline pressure |
If the support is weak, the software cannot rescue the bookkeeping on its own.
The open-item register
Every month, create a short list of unresolved items:
| Item | Description | Owner |
|---|---|---|
| Old bank difference | ||
| Supplier query | ||
| Customer allocation issue | ||
| VAT explanation needed |
The point is not complexity. The point is preventing repeated drift.
Sage controls that should not be left to software defaults
Sage can support a clean process, but the file still needs human review. Automated rules, recurring journals, and copied supplier records can make the file look active while errors quietly repeat.
Review these settings and habits:
| Control point | Practical check |
|---|---|
| Bank rules | Confirm rules still code recurring items correctly |
| Supplier records | Remove duplicates and inactive records where appropriate |
| Customer allocations | Check receipts are not sitting unallocated |
| VAT setup | Confirm tax codes are used consistently |
| User access | Make sure the right people can process and review |
These are not once-off setup items. They should be revisited when the business adds new bank accounts, suppliers, sales channels, or finance staff.
VAT control in a Sage file
VAT review should not start on the filing deadline. Sage bookkeeping needs monthly VAT discipline so the VAT201 return can be supported without rebuilding the file.
Check:
- whether VAT control agrees to the working VAT report
- whether unusual tax-code entries have been reviewed
- whether supplier tax invoices support input claims
- whether credit notes and refunds have been treated correctly
- whether old VAT differences are explained instead of carried forward
Where VAT is the weak point, pair this checklist with the VAT reconciliation checklist. The Sage file should explain the return, not merely produce a number.
How to review old balances
Old balances are the main reason a current Sage file still feels unreliable. They often sit in trade debtors, trade creditors, suspense, clearing, director loan, or VAT control accounts.
Use this sequence:
- identify balances older than the business's normal cycle
- ask whether the balance is real, disputed, duplicated, or unknown
- find the document or statement support
- assign an owner and target month for resolution
- decide whether an adjustment is needed
Do not clear old balances just to make a report look neat. The adjustment should be supported, approved, and understandable to the year-end reviewer.
When Sage bookkeeping is ready for handoff
A good Sage file should be easier for an accountant or reviewer to use. Before year-end, finance handoff, or a bookkeeper change, confirm that the file can stand on its own.
The handoff should include:
- last reconciled bank month
- supplier and customer age analyses
- VAT support and recent VAT201 returns
- fixed asset and loan schedules
- open-item register
- notes on unusual journals or adjustments
If the business is preparing to move systems, use the Pastel to Xero migration checklist or Xero bookkeeping checklist to keep the Sage history from becoming a loose archive.
Monthly reviewer checklist
Someone should review the Sage file after processing, even if the same person also did the capture. The review is where repeated errors are caught before they become part of the reporting habit.
The reviewer should scan bank reconciliation status, old customer and supplier balances, VAT control, suspense or clearing accounts, and material journals. The review should also check whether recurring transactions were posted consistently and whether unusual items have support.
This does not need to be a long report. A short review note is enough if it records the period reviewed, the main exceptions, who owns each exception, and whether the month can be used for management decisions.
If no one is doing that review, the business is relying on Sage activity rather than Sage control. That is usually where small monthly issues become year-end problems.
Cleanup triggers in Sage
Some Sage issues should trigger cleanup rather than another ordinary month-end. Examples include several unreconciled bank periods, unexplained VAT control differences, duplicate customer or supplier accounts, suspense balances with no owner, and journals that cannot be explained.
When those appear together, the business should separate cleanup from normal monthly processing. Otherwise the same weak balances are carried forward while the file continues to look current.
The cleanup plan should name the affected accounts, the period being repaired, the owner, and the evidence needed before adjustments are posted.
It should also protect current processing. The business still needs a live monthly routine while old Sage issues are repaired. Keep current bank, supplier, customer, and VAT work moving separately so cleanup does not become another reason the latest month falls behind.
That separation makes progress visible: current work stays current, while historical issues are fixed through a defined cleanup list with evidence and approvals.
It also helps management see whether the file is improving or merely staying busy, especially before VAT review, year-end, or handover.
When the checklist shows a deeper problem
If several of the following are true, the business may need stronger intervention:
- reconciliations are behind by more than one cycle
- supplier or customer ledgers cannot be explained
- open items are being normalized
- reporting confidence is dropping every month
At that stage, a Sage bookkeeping service or cleanup project is safer than hoping the next month will somehow solve it.
How this page supports the bookkeeping cluster
This checklist should be used with:
- Sage bookkeeping services
- bookkeeping documents checklist
- month-end bookkeeping checklist
- what Sage bookkeeping still needs a human to review
The right outcome is a file that management can rely on, not just a system that looks current on the surface.