Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am trying to customize a check register for our bank so I can download it as a csv file. My problem is I cannot get the account number to appear on the report. I have account name but not the account number since we have 74 LLCs with thier own bank accounts. The Bank report for positive pay needs to have the following columns -
Account Number - Date - Check Number - Void - Payee Name - Amount -
Any suggestions would be greatly appreciated.
Thanks,
Gerard
I can help in generating the report that you need, gangelo.
You can run an Account List Report in QuickBooks Online (QBO) to include the account number on the report.
Here’s how to generate the report:
Check this article for more information on how to get the most out of your financial reports: Customize reports in QuickBooks Online.
Let me know if there's anything that you need in generating this report. Have a wonderful day!
Hi MaryJoyD,
Thanks for your reply. I was looking for a more of a check register with the bank account numbers.
Thank you for getting back here, @gangelo.
To enable the account numbers in your check register, please follow these steps:
Once finished, you can now add the account numbers by going to Chart of Accounts. Click the drop-down arrow under the Action column and choose Edit. From there, you can enter the last 4 digits of the account number on the bank name.
To see the changes go back to the Chart of accounts, click the Run Report from the drop-down. Go to the gear icon and click Show more then, put a checkmark in the box beside Account # and select Run Report.
For more details about the customizing report, you may refer to the steps provided by my colleague, MaryJoyD.
Also, in QuickBooks Online you have the option to save your modified reports so you can run them in the future. Please see the Manage your custom reports in this article: Customize reports.
Keep in touch if there's anything I can help you with. I'm always around to provide further assistance. Have a good one.
I don't see the screen you are referring to. I have the 2020 version of Quickbooks Online Enterprise edition. Not sure if that makes a difference.
I think I'm causing some confusion. We are using QuickBooks online but cloud based hosted by a third party if that makes a difference.
Thanks for clarifying what version of QuickBooks you have.
Enterprise is actually a Desktop version of QuickBooks and does not have an online version. Also, we're unable to run a bank register report with an account number.
You'll want to export an account Quick Report to Excel. Then, add a column where you can add an account number to it. Here's how to export the report:
Here are some of the articles about customizing reports in QuickBooks Desktop to share more details with you:
The Community is always here if you need more help with your banking transactions and when running reports.
To create positive pay files from QuickBooks Enterprise use our BRC PositivePay file Creator - QB Desktop
It supports well over 100 bank file formats as well as the ability to create your own custom file formats.
I have Quickbooks Enterprise Solutions 24.00
I need to creak a check register for Positive pay as well.
How can I include the bank account as well as the check register format for the bank
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here