Sage Business Cloud Accounting Bank Reconciliation

To reconcile a Sage Business Cloud Accounting bank account, identify the Australian client file, compare its recorded movements with the statement and explain every remaining item. If your client calls it Sage One, confirm the product before using its banking instructions.

Identify the Sage Product and Client Company

Open the client company assigned to your own practice login and confirm that it is the Australian Sage Business Cloud Accounting file you intend to reconcile. Record the company identity, product edition and region in your working papers. Sage One is older wording you may encounter for this product family. The client’s file and agreement must establish which product they actually use.

Sage’s Australian adviser agreement describes an Accountants Edition with a Client Console. That practice view is the starting point for choosing a client, rather than evidence that you have opened the correct bank account.

Confirm that the client authorises your practice to work on the records. Use named staff access with permission for that company and the banking work required. Sage’s Australian user-access guide describes assigned client companies and permissions for Accountants Edition users.

Sage Intacct and Sage 50 have separate banking procedures. Foreign editions of Sage Accounting also have different controls. Use the help attached to the identified Australian edition when selecting its banking actions. A familiar Sage logo alone does not establish that a foreign help article applies.

Before changing anything, agree the bank account identifier against the statement. Check its currency, the company’s GST reporting basis and the last accepted reconciliation. Keep the GST basis with the file because a bank match alone does not settle the tax treatment of the underlying entry.

Prepare the Statement and Opening Records

Collect the complete bank statement and the prior accepted reconciliation before you import or select movements. Include the bank ledger detail, source receipts and payment records. Record the statement boundary, with earlier outstanding items carried forward separately.

1. Compare the opening bank ledger with the prior accepted closing ledger. Then agree the statement opening balance to the previous statement’s closing balance. Explain any difference using the prior outstanding-item list.
2. Open the selected account’s banking records in the Australian client file. Compare the available statement-input route with that edition’s own help before loading a file or using an existing bank connection.
3. Check the first and last statement movements against the records already present. Identify missing periods and overlaps before adding anything. Keep the original statement file so another staff member can repeat the comparison.
4. Inspect potential duplicates against the original source. The same amount can be two genuine payments. Compare the reference and direction as well as the amount and transaction date.

An imported line shows that transaction data has reached the file. Reconciliation requires a further comparison of the statement balance, recorded movements and outstanding items. Keep the complete statement even when the banking screen marks imported items as matched or reviewed.

If the opening records disagree, resolve that difference first. Adding the current statement’s movements to an unexplained opening balance carries the error into the next period.

Match the Bank Movements in Sage

Work through the selected Sage bank account against the statement, preserving each movement’s accounting purpose. A customer receipt settles money received. A supplier payment records money paid. A transfer moves money between accounts and must agree on both sides.

5. Locate each statement movement in the client’s bank records. Match an existing receipt or payment before considering a new entry. Compare its amount, direction and reference with the source document.
6. Use the identified edition’s matching or reconciliation selection for movements supported by the statement. Leave a recorded payment outstanding when it has not cleared. Avoid selecting an item solely because its amount makes the difference disappear.
7. Record a genuinely missing bank movement through the appropriate banking entry for that edition. Confirm the bank account and underlying expense, receipt or transfer before saving. Retain the source and approved tax treatment with the adjustment.
8. Compare the resulting bank ledger with the statement after allowing for evidenced outstanding items. Confirm the account and period again before accepting the work.

Sage’s Australian payment-gateway guide illustrates why matching and transfers need separate attention. In its eWay example, matching merges the recorded receipt with the imported gateway movement when the items move to reviewed. The later settlement into the actual bank is treated as a transfer against the gateway account. Recording that settlement as fresh sales would count the receipt twice.

Fictional Sage Bank Exercise

Assume an Australian client’s operating bank ledger and statement both start at $10,000, with no earlier outstanding items. The statement contains a $2,200 customer receipt, a $1,100 supplier payment and a $20 bank fee. Its closing balance is $11,080.

The Sage ledger already contains the receipt and supplier payment. It also contains a separate $600 supplier payment that clears in the following statement period. The $20 bank fee is missing. Assume the bank evidence identifies that fee as GST-free.

Before the fee entry, the ledger closes at $10,500. After recording the fee, it closes at $10,480. The statement’s $11,080 less the outstanding $600 payment also equals $10,480.

Incorrect selection: marking the $600 payment as cleared because it is already in Sage. Correct selection: leave it outstanding until the bank evidence shows it cleared. The expected result is agreement after the $20 correction, with the $600 supported as a timing item.

Correct Unreconciled Items

Investigate the first unexplained movement before changing the reconciliation. Keep a copy of the existing records and distinguish an open period from one the practitioner has already accepted.

For an open period, correct the identified entry and repeat the comparison before accepting the reconciliation. Keep the transaction reference and explanation of what changed.

For an accepted period, have the responsible practitioner approve the correction route first. Record who approves it and which later periods need checking. Do not apply an undo or delete procedure from a different Sage product. Preserve the original reconciliation alongside the revised evidence so the reviewer can follow the change.

A timing item has an identifiable underlying movement and evidence explaining why it sits outside the statement period. Later clearance can support that explanation. A difference with no identified transaction remains unexplained, even when it is small. Never post an unsupported amount to bank fees or a suspense account simply to make the balances agree.

Retain the Sage Report for Review

Save the reconciliation output available in the identified Australian edition, together with the underlying bank ledger detail and outstanding movements. If the file provides no separate completed-period report, retain readable copies of its reconciliation view and supporting records as equivalent evidence.

Check that the retained output identifies the client company and bank account. Compare its period and closing balance with the statement, then trace each outstanding movement to its supporting record. A screenshot of a zero difference alone leaves the reviewer unable to reconstruct the work.

For the fictional exercise, the review file must show the $11,080 statement balance and $10,480 adjusted ledger balance. It must also show the $20 fee entry and the separate $600 outstanding payment. These values explain the agreement without implying that every recorded payment has cleared.

Give the reviewer the statement, reconciliation output, adjustment evidence and outstanding-item list. Add a preparer’s handover stating the period completed, unresolved matters and any changes to accepted periods. Record review acceptance explicitly, with the reviewer’s identity and acceptance date. Keep any qualification beside that decision.

Open the saved files from the practice’s retained folder before closing the job. Confirm that the pages are complete and readable without relying on the preparer’s Sage login. Keep authorised copies under the practice’s record policy so a later staff departure, client handover or subscription change does not remove the evidence needed to understand the reconciliation.