Statement converter
Wells Fargo statement to Excel
Wells Fargo business and consumer checking statements often print Credits and Debits as two positive columns, plus a balance. A number in the debit column is money out even though it is not printed with a minus.
What we look for
Download the PDF from Wells Fargo online banking under Statements and documents. The summary uses Beginning balance and Ending balance. The transaction history then uses Date, Description, Credits, Debits, and Balance.
Northline puts credits into the deposit column and debits into the withdrawal column. The signed amount is what has to carry the beginning balance to the ending balance. Each printed running balance is also compared with the balance implied by the rows above it.
If a daily balance looks wrong
Sometimes the final totals agree and one intermediate balance does not. That is a different failure from an ending balance that is simply off. The badge says to check running balances, and the row is highlighted, so you can see which line broke the chain.
Questions
Can I export this to QuickBooks?
Yes. The QBO download is an OFX file QuickBooks can import. Match it to the right account in QuickBooks. It is not a live bank feed.
Northline is not affiliated with the bank named on this page. This is not tax or financial advice. Compare the export to the original statement. Read the disclaimer.