How to manually add a bank statement

Welcome to the Community space, @ok hogan.

Let me help you on how to add bank statements in QuickBooks Online (QBO).

To clarify, if you're referring to adding transactions to the bank statement, I can guide you through the process. However, there is no option to add the entire statement. Let me walk you through how:

Step 1: Pick a start date

To avoid entering duplicates, you need to know the date of the oldest existing transaction currently in the account:

1. Go to Settings ⚙. Then, select Chart of Accounts.
2. Find the account you want to upload the transactions into. Then, select View Register.
3. Find the oldest transaction, then write down the date.
4. Note: Usually, the oldest transaction is the opening balance.

Step 2: Get transactions from your bank

To get transactions from your bank, you need to download CSV files of your transactions.

1. Sign in to your bank or credit card's website.
2. Follow your bank's instructions on how to download CSV files of your transactions to your computer.
3. Note: Every financial institution has different steps. Here are steps for Bank of America, Chase, and Wells Fargo.
4. Check the date range for the download. It should be at least one day before the date of your oldest transaction.
5. Download your transactions. Save the file somewhere you can easily find it, like your computer's desktop.

Tip: Your bank may offer a few file formats. If possible, pick the QuickBooks Online data (QBO) format. These are formatted specifically for QuickBooks Online. You can also upload transactions from a CSV or Quicken (QFX) file.

Step 3: Review the file format and size

Review the file you download from your bank and make sure it's in the correct format before you upload it. Here are the things to check to prevent errors:

Note: The maximum file size is 350 KB. You can shorten the date range and download transactions in smaller batches if the file size is too big.

• Remove any zeros (0) from the file and leave those cells blank.
• Fix any transactions that show numbers in the Description column.
• Remove the word “amount” from the Credit or Debit column header. They should only say “Credit” and “Debit”.
• Make sure that all dates follow the same format. We recommend you use the dd/mm/yyyy format.
• If you’re a Mac user, make sure to save the file as Windows CSV file.
• Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). You need to remove the day of the week. To do this, split the date and the day of the week into separate columns.

CSV file formats

Step 4: Manually upload the transactions

1. Go to Transactions, then select Bank Transactions.
2. Select the blue tile for the account you want to upload the transactions into.
3. Select the Link account▼ dropdown, then select Upload from file.
4. Note: If your account is not connected yet to online banking, select Upload from file.
5. Select Drag and drop or select files and select the file you downloaded from your bank. Then, select Continue.
6. In the QuickBooks account▼ dropdown, select the account you want to upload the transactions into. Then, select Continue.
7. Note: If you're new to QuickBooks, you may not have an account to upload the transactions into. If you don't see one, select Add New ▼ from the dropdown to create a new bank account.
8. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
9. Select the transactions you like to import. Then select Continue.
10. Select Yes.
11. Select Done.

If you see an error message, here’s how you can fix errors when you upload transactions.

Step 5: Categorize the transactions

Now that your transactions are in QuickBooks, it's time to match and categorize them. The transactions go into your accounts after you review them.

QuickBooks Online also enters certain details automatically if you set up any banking rules, or if it recognizes transaction descriptions.

Step 6: Reconcile the transactions

Reconcile the transactions that you uploaded. This is to make sure that all transactions are recorded correctly in QuickBooks.

Additionally, here are some articles that you can read to help speed up and learn how to add transactions directly to an account register also, how to connect your bank and credit card accounts to QuickBooks Online:

• Manually add transactions to account registers in QuickBooks Online
• Connect bank and credit card accounts to QuickBooks Online

Fill me in if you need more guidance about your bank transactions in QuickBooks Online. I'm always ready to back you up. Take the best care!

Steps on how to manually add a bank statement:

• Download your statement

  • Grab the CSV (or QBO/QFX/OFX) file from your bank if available.

  • If only PDF is offered, download that instead.

• Ensure correct format or convert PDF

  • CSV option: Make sure it has only Date, Description, and Amount (or Credit/Debit) in 3 or 4 columns, is under 350 KB, and uses consistent date formatting.

  • PDF option: Convert it to the proper CSV format using a PDF-to-CSV tool (e.g., SupaClerk.com , docuclipper, others) before proceeding.

• Upload the file

  • Go to Transactions → Bank transactions → Link account → Upload from file, select your completed CSV, map the fields, and import.

• Match and reconcile

  • In QuickBooks, review the imported items, match them to existing entries, categorize, and reconcile as usual.