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.
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!
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.
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.