For Sage 300 CRE and Sage 300 ERP
Sage 300 bank reconciliation software for Sage 300 CRE deposits, ACH and checks
Import Cleared Checks takes care of the checks. Owner draws, retainage releases, payroll funding and equipment loan debits still get ticked by hand. Upload the statement and a Sage 300 cash export and get every line matched.
No Sage add-on. No partner project. No bank login.
Try one month now. Files encrypted, demo files deleted after 24 hours.
Reconcile my Sage 300 account
The short answer
Sage 300 CRE reconciles a bank account in Cash Management. Import Cleared Checks clears checks from a bank file, but deposits, payments and transfers are still marked one by one. Matching the full statement against a Sage 300 export first turns that into a finished list, so the reconcile task is a few minutes of clearing, not an afternoon.
What Import Cleared Checks leaves for you to clear by hand
A Sage 300 CRE user asked in the Sage community whether bank reconciliation could be automated with a file import and matching. The answer from Sage was clear: the import clears checks, and deposits, payments and transfers are not part of it. On a contractor's operating account, those are most of the money.
Deposits
Progress payments and draws
Owner and GC payments arrive as wires and ACH credits, often net of retainage, and rarely in the same grouping as the receipts in Sage.
Payments
ACH to vendors and lenders
Electronic payables, equipment notes, insurance and bonding premiums debit the account without a check number to import.
Transfers
Payroll and job account funding
Sweeps between operating, payroll and project accounts post on both sides with different dates and descriptions.
Bank only
Fees nobody entered
Analysis charges, positive pay fees, returned items and interest that exist on the statement and nowhere in Sage.
How to reconcile a Sage 300 bank account in four steps
-
Export the cash account
Run the general ledger detail for the cash account for the statement month and export it to Excel. Keep the date, the reference and either Debit and Credit columns or one signed amount. A debit to cash reads as money in, a credit as money out.
-
Get the statement
The PDF from online banking works. So do CSV, XLSX, OFX, QFX, QBO, MT940 and CAMT.053 from treasury portals. Nothing to configure per bank, see supported formats.
-
Six matching passes run
Exact amount and date, then check number, then amount inside a date window, then grouped deposits that add up to the cent, then duplicates and near matches. Every transaction type goes through the same passes, not only checks.
-
Clear and reconcile in Sage
Keep using Import Cleared Checks if you have it. Clear the remaining deposits, payments and transfers from the matched list, enter fees and interest from the adjusting entries file, and run the reconcile task with a zero difference.
OPERATING, September
Statement vs Sage 300
| Date | Sage line | Amount | Status |
|---|---|---|---|
| 09/02 | CK 20871Subcontractor, cleared by import | -38,400.00 | Cleared |
| 09/08 | Progress pmt, Job 2214Wire, net of 10% retainage | 186,750.00 | Matched |
| 09/11 | Transfer to payrollBank posted 09/12 | -92,318.64 | Matched |
| 09/15 | Equipment note ACHNo check number | -6,412.08 | Matched |
| 09/30 | Positive pay feeNot in Sage | -145.00 | Adjust |
What you get back for each Sage 300 bank account
Cleared list
Every line to clear, not only checks
Deposits, ACH, wires and transfers paired with their Sage entries by date, amount and reference.
Grouped receipts
One deposit, several receipts
Combinations of up to six receipts from the 14 nearest by date tested for an exact sum, the same engine as matching bank deposits to invoices.
Missing in Sage
Bank activity nobody keyed
Fees, interest, returned items and lender debits that are on the statement and not in Cash Management.
Outstanding items
Checks still out with subs
Uncashed checks carry to next month on their own and build the outstanding checks list your auditor and bonding agent ask for.
Adjusting entries
A CSV of what to post
Date, description, suggested account and amount for each missing item, ready to key as a bank entry or a GL batch.
Report
A file per account per month
A PDF and XLSX bank reconciliation report with statement balance, outstanding items, adjusted balance and preparer.
Who reconciles Sage 300 this way
General and specialty contractors
Sage 300 CRE shops with an operating account, a payroll account and sometimes a separate account per large job. Lenders and sureties want monthly reconciliations on time, and the person doing them also runs AP and job cost.
Real estate owners and managers
Portfolios that keep one bank account per property in Sage 300 CRE, where rent deposits arrive in batches and every account has to tie out before owner reporting.
Outsourced construction accountants
Firms that close several contractor clients on different ledgers. Each company gets its own workspace on the Business and Firm plans. See bank reconciliation for accountants.
Three ways to reconcile a bank account in Sage 300
| Task | Clear by hand | Import Cleared Checks | BankReconciler first |
|---|---|---|---|
| Setup | None | Bank file in the layout Sage expects | None, upload two files |
| Checks | Ticked one at a time | Cleared from the file | Matched by number, amount and date |
| Deposits, ACH, transfers | Ticked one at a time | Not covered, ticked by hand | Matched, grouped deposits included |
| Missing bank items | Found when the difference will not clear | Same | Listed with an adjusting entry |
| Where you reconcile | In Sage | In Sage | Still in Sage, from a finished list |
| Cost | Included, plus staff hours | Included | From $49 a month, see pricing |
If your account is almost all checks and the import already clears them, you may not need us. The case for matching outside Sage is the account with wires, ACH and transfers, which on a busy contractor's books is most of the activity. Teams with dozens of accounts and treasury rules may prefer a full close platform, and our automated bank reconciliation page explains how the matching passes work in detail.
Sage 300 bank reconciliation questions
How do I do a bank reconciliation in Sage 300 CRE?
In Cash Management, enter the bank statement for the account with its ending balance. Clear checks by hand or with Tools, Import Cleared Checks, then mark the deposits, payments and transfers that cleared. When the cleared total ties to the statement, run Tasks, Reconcile with Reconcile cleared entries checked, and print the reconciliation report for the month.
Can Sage 300 CRE automate bank reconciliation?
Partly. Import Cleared Checks reads a bank file and clears the matching open checks, and the reconcile task then picks up everything cleared on or before the statement date. In the Sage community, Sage confirmed the import does not cover deposits, payments and transfers, so those stay manual unless you match them outside Sage first.
Why is my Sage 300 bank reconciliation out of balance?
The usual causes are a voided check that was not cleared correctly, an entry posted straight to the cash GL account without going through Cash Management or Bank Services, a deposit recorded in a different grouping than the bank shows, a duplicate entry, or a bank fee nobody entered. Matching the statement to the ledger lists the exact line instead of a bare difference.
Does this work with Sage 300 ERP, the former Accpac?
Yes. In Sage 300 ERP the reconciliation lives in Bank Services, Bank Transactions, Reconcile Statements. Export the cash account detail for the month, match it against the statement here, then clear the matched lines and post the bank fees in Reconcile Statements. Nothing about the matching depends on which Sage 300 you run.
Do I need to install anything in Sage 300?
No. You upload an export and the bank statement. There is no add-on to install, no database access and no bank login to share, so your Sage partner and IT team do not need to be involved. Files are encrypted in transit and at rest, as described on the security page.
Clear deposits and ACH as fast as the check import
Upload last month's statement and a Sage 300 cash export. Clear from a finished list.