Import Bank Statement into Sage 50, Sage 300 and Intacct from PDF

Can Sage import a PDF bank statement?

No US Sage accounting product reads a PDF bank statement. Sage 50, Sage Intacct and Sage 300 import OFX, and Sage 300 CRE imports a cleared checks text file built from a spreadsheet. Convert the PDF statement with the tool above to OFX or CSV, then use the import screen for your Sage product. The table shows which file each one takes.

The word Sage covers several unrelated programs, and the import route depends entirely on which one you run. The guides below are written for the US editions and follow each product's own help documentation. UK and Canadian editions of Sage 50 and Sage Accounting have different menus and formats.

Import a bank statement into Sage 50 U.S.

Sage 50 U.S. imports a statement in OFX or QFX format from Tasks, Account Reconciliation. Pick the account and statement date, choose Import, select the file manually and import it. Sage notes three limits worth knowing before you start: the import works one month at a time, it marks transactions as cleared but does not create new transactions in Sage, and it is not available in Pro Accounting. A PDF has to be converted first. The full walk through is on the Sage 50 bank statement converter page, and if your bank feed stopped downloading, read the Sage 50 bank feeds not working guide.

Import a bank statement into Sage Intacct

Sage Intacct has two import routes in Cash Management. The classic reconciliation import reads CSV and QIF with dates as MM/DD/YYYY. The newer Bank transaction assistant also reads XLS, XLSX and OFX, and matches imported lines against the account's rule set. OFX is usually the cleaner file because it skips the classic import's fixed column names. See Sage Intacct bank reconciliation import from PDF statements.

Import a bank statement into Sage 300 ERP

Sage 300 Bank Services imports OFX from Common Services, Bank Services, Bank Transactions, Import OFX Statements, against a bank code. Reconcile E-Statements then matches each line on amount and on reference, payee or comment, and anything left over is cleared by hand or recorded with Bank Entry before you post. Step by step: Sage 300 bank reconciliation with OFX import from PDF statements.

Import cleared checks into Sage 300 CRE

Sage 300 Construction and Real Estate clears checks from a text file with four fields, bank account, check number, amount and cleared date, through Tools, Import Cleared Checks in Cash Management. Deposits and transfers are cleared on screen. Converting the PDF statement to CSV and reshaping the check lines in Excel gives you a file that matches your import format on the first try. Read Sage 300 CRE bank reconciliation with cleared checks from PDF statements.

Why a converted file beats retyping

Every one of these imports exists so that nobody keys a statement in by hand, and every one of them stops at the PDF. A converted file carries the posting date, amount, payee and description of each line exactly as printed, so the matching Sage runs afterward has real data to work with. Check the rows against the beginning and ending balances printed on the statement before you import, and work one month at a time, oldest first, when you catch up a year.

What it costs

OFXStatement Starter is $49 a month, or $24.50 a month on the annual plan, for 2,500 pages from one shared pool, with statements up to 25 pages each. Plus is $149 a month for 10,000 pages, no per statement page cap, and bulk upload of up to 50 files at once for firms that reconcile many Sage clients. You can test 15 pages without a credit card before you pay.