Solved

Export / import bank register

Forum|Forum|1 year ago
December 23, 2024
1 reply
0 views

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.

QuickBooks Online

Best answer by RhoiceW

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:

Go to the Gear icon and select Chart of accounts.
Look for the account you want to get a copy with and select View Register.
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:

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

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.

R

RhoiceWAnswer

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:

Go to the Gear icon and select Chart of accounts.
Look for the account you want to get a copy with and select View Register.
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:

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

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.

J

JackDAuthor

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

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.