cancel
Showing results for 
Search instead for 
Did you mean: 
JackD
Level 2

Export / import bank register

Is there any way to export a copy of the complete bank register? I can export all of the account settings (chart of accounts, customers, employees) but need a full copy of our 13,700+ page bank register going back to 2002. We're having issues with the account synching to the bank and the last time we tried resetting it we almost lost the entire register (the bank itself only goes back 1 year). Need to have a copy to re-import if necessary. Thanks.

Solved
Best answer December 23, 2024

Best Answers
RhoiceW
QuickBooks Team

Export / import bank register

Hi there, Jack. Yes, there's a way to export a copy of your bank register. I can show you the steps to get a copy of data in QuickBooks Online (QBO).

 

You can get a copy of your bank register by going to your Chart of accounts.

 

Here's how:

 

  1. Go to the Gear icon and select Chart of accounts.
  2. Look for the account you want to get a copy with and select View Register.
  3. On the top right corner of the page, click the Export icon.

 

After exporting it, you can view the file that can be found in your computer documents.

 

Another option is to run a Transaction Detail by Account report. This way, you can display your records and filter them all the way back to 2002.

 

Here's how:

 

  1. On the left panel of your account, click Reports.
  2. Enter Transaction Detail by Account in the search bar.
  3. On the Report period, click the dropdown arrow and select All Dates.
  4. Click the More actions dropdown, then select Export to Excel or Export as CSV.

image.png

 

Additionally, you can refer to this article to learn about managing your bank transactions while importing them into QBO:

 

 

Enhance your financial trajectory by working with our QuickBooks Live Expert Assisted team. These financial maestros streamline your processes and provide bespoke advice to meet your business's unique needs. Click now to embark on a new era of financial clarity and success.

 

Your success in managing your transactions is essential for your business. If you have more questions about exporting/importing transactions, let's address them together. I'm here to make sure you have the support you need to keep things running smoothly.

View solution in original post

3 Comments 3
RhoiceW
QuickBooks Team

Export / import bank register

Hi there, Jack. Yes, there's a way to export a copy of your bank register. I can show you the steps to get a copy of data in QuickBooks Online (QBO).

 

You can get a copy of your bank register by going to your Chart of accounts.

 

Here's how:

 

  1. Go to the Gear icon and select Chart of accounts.
  2. Look for the account you want to get a copy with and select View Register.
  3. On the top right corner of the page, click the Export icon.

 

After exporting it, you can view the file that can be found in your computer documents.

 

Another option is to run a Transaction Detail by Account report. This way, you can display your records and filter them all the way back to 2002.

 

Here's how:

 

  1. On the left panel of your account, click Reports.
  2. Enter Transaction Detail by Account in the search bar.
  3. On the Report period, click the dropdown arrow and select All Dates.
  4. Click the More actions dropdown, then select Export to Excel or Export as CSV.

image.png

 

Additionally, you can refer to this article to learn about managing your bank transactions while importing them into QBO:

 

 

Enhance your financial trajectory by working with our QuickBooks Live Expert Assisted team. These financial maestros streamline your processes and provide bespoke advice to meet your business's unique needs. Click now to embark on a new era of financial clarity and success.

 

Your success in managing your transactions is essential for your business. If you have more questions about exporting/importing transactions, let's address them together. I'm here to make sure you have the support you need to keep things running smoothly.

JackD
Level 2

Export / import bank register

Thanks - the issue I' having is that only exports records to a certain point - record 2501 of 13749 (page 51 of 275). Is there a way to set a range to export all? Thanks.

Tori B
QuickBooks Team

Export / import bank register

Good evening, @JackD.

 

Thanks for taking the time to get back to us. I hope you're having a great day so far. 

 

I recommend running a quick report of the account and then exporting the report to Excel. This way all of your data can be exported at the same time. I'm including some steps to walk you through the process below. 

 

  1. Open the account register.
  2. Click on the drop-down arrow next to View Register.
  3. Choose Run Report.
  4. Customize the date range of the report as you see fit.
  5. Tap on Export to Excel.

 

That should do the trick. Please don't hesitate to let me know if you have any additional questions or concerns. Take care! 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Want more ways to get paid?

A business owner is using a card reader to take a customer's payment.

Make it easy for customers to pay you, and manage it all in QuickBooks.

Explore QuickBooks Payments

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up