Upload the PDF statement and download an OFX or QFX file for the Sage 50 Import Statement wizard, with every transaction, check number and balance carried over. Built for bookkeepers and controllers who close Sage 50 companies from PDF statements, and for anyone catching up months the bank no longer offers as a download.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV
Uploading...
Sage 50 cannot read a PDF bank statement. The Import Statement wizard under Tasks > Account Reconciliation takes a file in standard OFX or QuickBooks QFX format, according to Sage 50 US help. Convert the PDF to OFX or QFX, import it from the reconciliation window, review the summary, then match the lines and reconcile to the statement ending balance.
Sage 50 reconciles well once the statement lines are inside. The delay is the file, because the wizard is narrower than most people expect.
The e-statement your client emails is a PDF. The Import Statement wizard cannot open it, and neither can it read a scan.
Sage 50 US help describes the wizard as importing a file in standard OFX or QuickBooks QFX format. A spreadsheet or CSV is not on that list.
Banks keep transaction downloads for a limited window while PDF statements go back years. Catch-up and migration months are usually PDF only.
Sage warns that re-importing a corrected statement could result in duplicate bank records, so a clean first file matters.
Keying a month of lines by hand invites a transposed digit, and a reconciliation that will not reach a zero difference.
A bookkeeper with ten Sage 50 companies receives ten PDFs a month in ten different layouts.
One file per account and statement period, in the format the wizard reads, with the same rows you see on the PDF.
The two formats Sage 50 US help names for the Import Statement wizard, available on the Plus plan.
Every plan exports Excel and CSV, useful for checking the rows, for pivoting, or for a second system.
Check numbers the bank prints stay in their own column, which makes matching against Sage 50 checks quicker.
Opening and ending balances travel with the rows, so you confirm the file ties before it touches your books.
On Plus, upload up to 50 PDFs in one batch when you are catching up a client or moving a company onto Sage 50.
Nothing connects to the bank or to Sage. Upload a statement, download a file, and delete the upload whenever you like.
The routine for any month you cannot download from the bank, using the Sage 50 US reconciliation window.
Upload the PDF and download OFX or QFX. Every transaction returns with date, description, check number and amount.
Tip: Check that opening balance plus deposits minus withdrawals equals the ending balance.
In Sage 50 choose Tasks > Account Reconciliation, select the account, click Import, browse to the file and click Import again. Review the summary.
Tip: Back up the company first. An import cannot be undone, and a repeat import can duplicate records.
Match each statement line to a Sage 50 entry, add the bank charges and interest it lists, and finish when the difference reads zero.
Tip: Import each statement period once, in date order.
US bookkeepers, controllers and small businesses that keep their books in Sage 50 Accounting.
Close several Sage 50 companies each month from the PDF statements clients forward.
Reconcile operating and payroll accounts when the bank portal only offers the PDF.
Rebuild a year of unreconciled months from archived statements before a tax filing or a loan review.
Bring prior months of bank activity in from PDFs after a switch from another system.
No. The Import Statement wizard in Sage 50 US is built for files, and the help page for it says it imports a file in standard OFX or QuickBooks QFX format. A PDF e-statement or a scanned paper statement is not on that list. In practice that means a PDF has to become an OFX or QFX file before Sage 50 will read it.
For last month that is rarely a problem, because most banks offer an OFX or QFX download for recent activity. It becomes a problem for older months. Many banks only keep downloadable transaction files for a limited window, while PDF statements go back years. A bookkeeper rebuilding a year of reconciliations, or a company that just moved onto Sage 50, ends up holding twelve PDFs and no importable file.
Sage documents the route in its Import a Bank Statement help topic. From the Tasks menu choose Account Reconciliation, pick the account in the Account to Reconcile field, click Import, enter or browse to the file in the Statement Location box and click Import. Sage 50 asks for the account information, then shows a summary of what the statement contained. Menu names can differ slightly between Sage 50 releases, so use the help for your version alongside this routine.
Two cautions come straight from that help page. A corrected statement has to be imported again, which can produce duplicate bank records, so a clean conversion the first time saves cleanup. And the import brings in interest and service charge items as well as debits and credits, so review the summary before you start matching.
| Output | Use it for | BankXLSX plan |
|---|---|---|
| OFX | Sage 50 Import Statement wizard, the standard format named in the help | Plus |
| QFX | Sage 50 Import Statement wizard, the QuickBooks flavor of the same format | Plus |
| Excel or CSV | Checking the rows, pivots, a second system, tax workpapers | Every paid plan |
If you only need the rows in a spreadsheet to review, Excel or CSV is enough. If the goal is to reconcile inside Sage 50, choose OFX or QFX. The same OFX file also works elsewhere, which matters for accountants who move clients between systems, as the OFX vs QFX vs QBO comparison explains.
A small distributor on Sage 50 has not reconciled its operating account since February. The bank portal offers downloads for the last 90 days only, but the nine PDF statements from March to November are in a shared folder, 4 to 6 pages each, about 45 pages in all. Converting them as one batch gives nine OFX files in date order. Each file is imported once from the reconciliation window, the summary is checked against the statement, and the account is reconciled month by month until the March opening balance and the November ending balance both agree with the bank. The work shifts from typing about 300 lines to reviewing nine summaries.
Other Sage products use different import screens, so check the right page before you convert: the Sage Intacct converter covers the cloud ERP, and the general Sage converter covers the wider family. For bookkeepers who clean up several clients at once, catch-up bookkeeping shows the batch routine, and reconciling bank statements walks through the zero-difference check.
No. The Sage 50 US Import Statement wizard imports a file in standard OFX or QuickBooks QFX format, not a PDF. Convert the PDF to OFX or QFX first. BankXLSX produces OFX and QFX on the Plus plan, and Excel and CSV on every paid plan.
Sage 50 US help names standard OFX and QuickBooks QFX. It does not list CSV or Excel for this wizard, so convert to OFX or QFX when you want to reconcile directly. Sage may add formats in newer releases, so check the help for your version.
Open the Tasks menu and choose Account Reconciliation. Select the account, click Import, browse to the file under Statement Location and click Import. Sage 50 asks for account information, then shows a summary of what the statement contained.
It can. Sage says that when a bank corrects a statement, you must import it again, and this could result in duplicate bank records. Import each period once, in date order, and back up the company before any import.
Sage 50 offers a bank connection through its Import Statement wizard in some regions and editions, but availability depends on your bank and version. When a bank is not supported or a month predates the connection, the file route from a converted PDF covers the gap.
Yes. BankXLSX reads scanned and photographed statements with AI visual OCR, so a scanned PDF becomes the same OFX, QFX, Excel or CSV file as a digital one. Check the balances against the page before importing.
For OFX and QFX, yes, because those formats are part of Plus along with QBO, QIF and IIF. Excel and CSV work on every paid plan. Plus also allows batches of up to 50 PDFs, which helps with catch-up months.
Import for the cloud ERP.
Rebuild months a feed cannot reach.
Convert a year of statements at once.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 800 pages |
| Pro AI Best accuracy | 80 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 1,920 pages |
| Pro AI Best accuracy | 192 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.