For Microsoft Dynamics GP checkbooks
Dynamics GP bank reconciliation software that marks the cleared lines for you
Select Bank Transactions with 600 open lines is where the close stalls. Upload the bank statement and a GP cash account export, and get the list of items to mark, the transactions GP is missing and the adjustments to enter.
No GP add-on. No partner project. No bank login.
Try one month now. Files encrypted, demo files deleted after 24 hours.
Reconcile my GP checkbookOPERATING, September
Statement vs GP
| Date | GP line | Amount | Mark |
|---|---|---|---|
| 09/03 | CHK 104418Payables check run | -12,906.40 | Mark |
| 09/05 | Deposit5 cash receipts, one batch | 48,215.18 | Mark, grouped |
| 09/12 | EFT 000391Bank posted 09/13 | -3,770.00 | Mark |
| 09/30 | Analysis feeNot in GP | -186.52 | Adjust |
The short answer
Dynamics GP reconciles a checkbook in Reconcile Bank Statements, where you mark each cleared transaction yourself, or with Electronic Bank Reconciliation once a file layout and match rules are set up per bank. A faster route is to match the statement against a GP export first. Software pairs the lines in seconds, so in GP you mark from a finished list and enter the few adjustments.
Why GP bank reconciliation still takes two days at month end
Select Bank Transactions is one long grid
A distributor with daily receipts and weekly check runs sees hundreds of open items per checkbook. Sorting by amount and marking one at a time against a PDF is most of the work, and a single missed line leaves a difference you then have to hunt for.
EBR only clears what the rules expect
Electronic Bank Reconciliation needs a configuration for each bank file layout and match criteria per checkbook. When a bank changes its BAI2 or CSV format, or the IT person who set it up has left, the import breaks and the team goes back to marking by hand.
Batch deposits never equal one receipt
Cash receipts entered one per customer land at the bank as one deposit, or the other way round when lockbox splits a day. One-to-one rules cannot pair them, so they fall through every month.
GL and checkbook drift apart
Journal entries posted straight to the cash account skip the checkbook, so the bank rec ties out while the GL does not. Finding that entry in a year of history is a job for the controller nobody has time for.
How to reconcile a Dynamics GP checkbook in four steps
-
Export the cash account from GP
Open the Account Transactions SmartList, restrict it to the cash GL account and the statement month, and export to Excel. Keep TRX Date, Reference, Debit Amount and Credit Amount. A debit to cash reads as money in, a credit as money out.
-
Get the statement from the bank
The PDF works. So do CSV, XLSX, OFX, QFX, QBO, MT940 and CAMT.053 from treasury portals. No file layout to configure, see supported formats.
-
Six matching passes run
Exact amount and date first, then check or EFT number, then amount within a date window, then grouped deposits that add up to the cent, then duplicates and near matches. You get back a short list of exceptions instead of a grid of 1,200 lines.
-
Mark and reconcile in GP
In Reconcile Bank Statements, open Select Bank Transactions and mark down the matched list. Enter fees and interest as adjustments from the adjusting entries file, and the difference is zero the first time.
What you get back for each GP checkbook
Marked list
Every line to mark, in GP order
Matched pairs with the check or EFT number and date, so the grid in Select Bank Transactions is a tick down the page.
Missing in GP
Fees, sweeps and wires nobody keyed
Analysis charges, merchant fees, loan payments and returned items that hit the bank and never reached the checkbook.
Outstanding items
Checks the bank has not paid
Open payables checks carry to next month on their own and feed the outstanding checks schedule your auditor asks for.
Grouped deposits
Receipts tied to the bank deposit
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.
Adjusting entries
A CSV of what to enter
Date, description, suggested account and amount for each missing item, ready to key as reconcile adjustments or a GL batch.
Report
Audit file per account
A PDF and XLSX bank reconciliation report with statement balance, outstanding items, adjusted balance and preparer.
Who reconciles Dynamics GP this way
Controllers at distributors and manufacturers
Companies with several operating, payroll and lockbox accounts at US banks, a lean AP and AR team, and a close calendar that cannot absorb two days of marking.
Teams staying on GP until they migrate
Microsoft ended new GP subscription sales on April 1, 2026 and ends support on December 31, 2029. Rather than fund a GP add-on project now, use a tool that keeps working on whatever ledger comes next, including NetSuite bank reconciliation.
Outsourced accounting firms
Firms that close GP clients alongside QuickBooks and Sage clients. Each company gets a workspace on the Business and Firm plans. See bank reconciliation for accountants.
Three ways to reconcile a bank account in GP
| Task | Reconcile Bank Statements | Electronic Bank Reconciliation | BankReconciler first |
|---|---|---|---|
| Setup | None | File configuration per bank layout, match rules per checkbook | None, upload two files |
| Single checks and EFTs | Marked by hand | Cleared when rules match | Matched by number, amount and date |
| One deposit, many receipts | Calculator | Usually left for manual review | Grouped when the receipts sum exactly |
| Bank changes its file | No effect | Configuration needs updating | Reads the new layout |
| Where you reconcile | In GP | In GP | Still in GP, from a finished list |
| After you leave GP | Gone | Gone | Same tool on the new ledger |
| Cost | Included | Depends on your GP licensing and partner time | From $49 a month, see pricing |
Where EBR is already configured and clears 95 percent of a checkbook, keep it, and use us only for the stubborn accounts. Where it was never set up, or broke when the bank changed formats, matching outside GP is quicker than a partner project on a product that stops getting updates in 2029. Larger GP shops with dozens of accounts and treasury rules may prefer a dedicated GP add-on. Our automated bank reconciliation page shows how the matching passes work in detail.
Dynamics GP bank reconciliation questions
How do I do a bank reconciliation in Dynamics GP?
Go to Transactions, Financial, Reconcile Bank Statements. Pick the checkbook, enter the statement date and the ending balance, then open Select Bank Transactions and mark every deposit, check and adjustment that cleared the bank. Enter bank fees and interest as adjustments with their GL accounts, and click Reconcile once the difference reads zero. Print the reconciliation report for the file.
What is Electronic Bank Reconciliation in Dynamics GP?
Electronic Bank Reconciliation, or EBR, imports a bank statement file into GP and clears the transactions that meet your matching rules. Before it works you configure the bank file layout, usually BAI2 or a CSV, and set match criteria for each checkbook. Lines the rules cannot pair, such as batched deposits, still wait for you to mark them manually.
Why is my Dynamics GP bank reconciliation out of balance?
The common causes are a journal entry posted straight to the cash GL account without going through the checkbook, a check voided in a later period, cash receipts deposited in a different grouping than the bank shows, a duplicate entry, or a bank fee nobody entered. A statement to ledger match lists the exact line rather than a bare difference.
Does this still work after Dynamics GP support ends?
Yes. BankReconciler reads exported files and does not depend on any GP version, service pack or year-end update. It works the same on GP today and on Business Central, QuickBooks or NetSuite after a migration, so the reconciliation process and history move with you.
Do I need to install anything in Dynamics GP?
No. You upload a GP export and the bank statement. There is no add-on to install, no Dexterity customization, no SQL access and no bank login to share, so your GP partner and IT team do not need to be involved. Files are encrypted in transit and at rest, as described on the security page.
Close the GP month without marking every line
Upload last month's statement and a cash account export. Mark from a finished list.