cancel
Showing results for 
Search instead for 
Did you mean: 
gangelo
Level 3

Check Register for positive pay

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 

 

7 Comments 7
MJoy_D
Moderator

Check Register for positive pay

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!

gangelo
Level 3

Check Register for positive pay

Hi MaryJoyD,

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

DivinaMercy_N
Moderator

Check Register for positive pay

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. 

 

accounts2.JPGaccounts3.JPG

 

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

 

accounts4.JPG

 

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. 

gangelo
Level 3

Check Register for positive pay

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. 

gangelo
Level 3

Check Register for positive pay

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. 

JenoP
Moderator

Check Register for positive pay

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:

 

  1. Look for the account in your Chart of Accounts.
  2. Right click on it and select Quick Report
  3. Click Excel in the upper part of the report, then select Create New Worksheet.

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. 

 

BigRedConsulting
Community Champion

Check Register for positive pay

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.

Need to get in touch?

Contact us