Yes, you can import prior bank statements using a CSV file, AWS_SmallBiz.
You can manually import data last year's statement. Download the bank statement from your bank using the following supported formats or file types:
- Comma-Separated Values (CSV)
- Quicken (QFX)
- QuickBooks Online (QBO)
- Microsoft Money (OFX)
Once the bank file is ready, start importing them to your QuickBooks Online company by following these steps:
- Go to the Banking menu and select Banking.
- Choose File upload from the Update drop-down. You can also select Upload transactions manually.
- Hit Browse and pick the downloaded file.
- Select Next.
- From the QuickBooks account drop-down list, choose the account to which to upload the bank transactions, and select Next.
- If you're using a CSV file, follow the prompts to select columns from the CSV file that match QuickBooks Online banking fields. Another option is through the Import Data page. To do so, click the Gear icon, select Import Data, then hit Bank Data.
- Click Next.
- Select Let's go! or Finish.
Once transactions are in, run the Profit and Loss report.
Also, I've attached an article on reconciling accounts to ensure your books are accurate.
Let me know if you need more help managing your bank transactions. I'll be glad to help you more.
