Skip to main content
G
gangelo
July 14, 2020
Question

Check Register for positive pay

  • July 14, 2020
  • 2 replies
  • 0 views

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 

 

2 replies

MJoy_D
MJoy_D
July 14, 2020

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:

  1. Go to the Reports tab from the left menu.
  2. Look for Account list and click to run the report.
  3. Click the Gear icon on the report to customize it.
  4. Add a check on each box to include the columns on 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!

G
gangeloAuthor
July 15, 2020

Hi MaryJoyD,

Thanks for your reply. I was looking for a more of a check register with the bank account numbers. 

DivinaMercy_N
DivinaMercy_N
July 15, 2020

Thank you for getting back here, @gangelo.

 

To enable the account numbers in your check register, please follow these steps:

 

  1. Navigate to the gear icon and click Accounts and settings.
  2. Select the Advanced tab and choose Chart of Accounts.
  3. Tick the pencil icon and put a checkmark in the box beside Enable account numbers and Show account numbers.
  4. Hit Save and then Done. 

 

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. 

BigRedConsulting
BigRedConsulting
September 30, 2020

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.

B
BlueAir
October 17, 2024

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

 

Terms & ConditionsAccessibility statement