Sage 100 bank reconciliation that explains every out of balance amount
Reconciles speeds up Sage 100 bank reconciliation when the month is too busy to clear line by line or the Reconciliation Summary shows an out of balance amount nobody can explain. You export the outstanding and cleared transactions for the bank code from Sage 100, upload them with the bank statement or processor payout file, and every bank line is matched to the deposit, check or entry behind it. What does not tie lands in an exceptions queue with the exact dollar gap. Plans are published from $888 a year.
Your files are processed in your browser and never stored. No card needed.
Where the Sage 100 Bank Reconciliation module slows you down
The Bank Reconciliation module in Sage 100 is solid for a quiet account. It lists the month's checks and deposits for each bank code, lets you mark them cleared with one keystroke, and the Reconciliation Summary compares the adjusted bank balance with the book balance. Sage Bank Feeds, added in version 2018.5, can bring bank lines in and propose matches. The trouble starts when the bank shows something different from what Sage 100 posted.
- A card processor deposits one net amount that covers a day of AR receipts, minus fees, so no single deposit in Sage 100 agrees with it.
- A cash receipts batch was posted as one deposit, but the bank split it across two days, or the reverse.
- A check was voided and reissued, and the old one still sits on the outstanding list.
- A journal entry was posted straight to the cash account in General Ledger and never reached Bank Reconciliation.
- A distribution company with several bank codes repeats the same hunt in each one, every month.
Any one of these leaves an out of balance amount on the Reconciliation Summary (Sage describes the report in its Bank Reconciliation Register help), and the module tells you the size of the gap but not which lines caused it. Reconciles looks at the whole month at once and names the lines.
How to reconcile Sage 100 with Reconciles, step by step
-
01 Export the bank code activity from Sage 100
Print the Bank Reconciliation Register for the bank code and period you are closing, or the General Ledger Detail Report for the cash account, and export it from the print preview to Excel. Keep date, check or deposit number, source, description and amount. Download the statement for the same account and period from your bank, plus the payout report from your card processor if deposits arrive in batches.
-
02 Upload both files
Drop the bank statement and the Sage 100 export into one workspace. Reconciles reads columns by content, so the register layout and your own report layouts are both recognized without a template.
-
03 Review matches and exceptions
Checks are matched by number and amount, deposits are matched to the receipts batches inside them, and processor payouts are rebuilt from their charges, refunds and fees. Every pair shows a reason and a confidence score. Stale checks, duplicates and lines with no counterpart wait in the exceptions queue with an owner and a comment thread.
-
04 Clear and adjust in Sage 100
Use the matched list to clear transactions in Bank Reconciliation in one pass. Export the approved fee and difference entries as a journal CSV and bring them in through Visual Integrator, or key the few lines in General Journal Entry. The out of balance amount on the Reconciliation Summary should then read zero.
Who uses Reconciles with Sage 100
- Distributors and manufacturers on Sage 100 with many customer checks, ACH receipts and lockbox deposits a day, see lockbox reconciliation software and check reconciliation software.
- Companies that take cards in a store, on a web shop or by phone and get one net deposit per day, see credit card processing reconciliation software.
- Sage partners and outsourced accounting firms that close the month for several Sage 100 companies, see reconciliation software for accounting firms.
- Controllers who inherited a cash account that has not tied for months and need a starting point, see bank reconciliation software.
What the matching catches in a Sage 100 month
- Checks still outstanding after 90 days, listed with their age so you can decide on a stale check review.
- Deposits in Sage 100 that the bank recorded on another day or as two lines.
- Bank lines with no entry in Sage 100, such as bank fees, returned items and interest.
- Card payouts whose charges, refunds and fees do not add up to the deposit.
- Voided checks that still appear as outstanding, and checks entered twice.
- Entries posted to the cash account in General Ledger that never reached the bank code.
Each one comes with the dollar amount, so the out of balance figure is explained line by line instead of with a plug entry.
Reconciles compared with the Sage 100 module and a spreadsheet
| Need | Sage 100 Bank Reconciliation | Spreadsheet | Reconciles |
|---|---|---|---|
| Clear checks and deposits for one bank code | Yes | By hand | Yes, and the whole month at once |
| Explain an out of balance amount line by line | No, shows the total gap | By formula | Yes |
| Rebuild card payouts from charges and fees | No | By formula | Yes |
| Reason and confidence for each pair | No | No | Yes |
| Same workflow for several companies | Per company | Per file | Yes |
| Price | Part of your Sage 100 license | Staff hours | $888 to $5,988 a year |
Keep Sage 100 as the ledger and keep its register as your record of what cleared. Add Reconciles for the months where the gap will not close. Other ledgers are on the integrations page, including Sage Intacct and QuickBooks.
One out of balance month in Sage 100, line by line
Say the October statement for the operating account ends at 182,406.15 and the Reconciliation Summary in Sage 100 shows an out of balance amount of 1,318.42. Nobody knows where it comes from.
Reconciles matches 412 of 431 bank lines on the first pass. Of the 19 left, three explain the whole gap. A card payout of 9,861.30 sits against two Sage 100 deposits of 5,120.00 and 4,968.92, so 227.62 of processor fees were never booked. A customer check for 1,090.80 was posted in Sage 100 on October 31 but cleared the bank on November 2, so it is a deposit in transit, not an error. The rest of the 19 lines are bank fees and a returned item already listed on the statement. Two adjusting entries go into the journal CSV, and the summary reads zero after you clear the matched lines.
Plans for Sage 100 companies
Starter is $888 a year billed yearly for 3,000 matched transactions a month. Growth is $2,388 a year for 20,000 a month across 5 entities, for groups with several Sage 100 companies. Scale is $5,988 a year for 100,000 a month across 25 entities, with API and SFTP, approvals and an audit log. Monthly billing is $149, $399 and $999. See pricing for the full limits.
Sage 100 bank reconciliation questions
Open the Bank Reconciliation module, choose the bank code, enter the statement date and ending balance, then mark each check and deposit that appears on the statement as cleared. The Reconciliation Summary compares the adjusted bank balance with the book balance. When the out of balance amount is zero, print the Bank Reconciliation Register and close the period.
Usually one of four things. A transaction was cleared that the bank has not processed, a voided check is still marked outstanding, a card deposit was booked gross while the bank shows it net of fees, or an entry went to the cash account in General Ledger without reaching Bank Reconciliation. Matching the full month against the statement shows which one.
No add-on is installed. Reconciles works from a report export of the bank code and your bank statement. Visual Integrator is only useful if you want to import the adjusting entries in one file; with a handful of entries, typing them into General Journal Entry is quicker.
Yes, the same way. Sage 100 Contractor is a different product from Sage 100, but both can export the cash account activity to Excel, and that export plus the bank statement is all Reconciles needs to match the month.
Reconciles publishes its plans. Starter is $888 a year billed yearly for 3,000 matched transactions a month, Growth is $2,388 a year for 20,000 a month across 5 entities, and Scale is $5,988 a year for 100,000 a month across 25 entities. There is no implementation fee.
Find last month's Sage 100 out of balance amount
Upload the bank statement and the Sage 100 register export. You will see what matched and which lines make up the gap, before you create an account.