Skip to main content
W
WW Accounting
February 24, 2020
Solved

How do you create a "check issued" report for csv export? We changed our banking account to a positive pay system and need to upload check runs each time we issue checks

  • February 24, 2020
  • 2 replies
  • 0 views
Original commenter did not share additional details
Best answer by BigRedConsulting

To create positive pay files using data from your QuickBooks Online company, use our BRC PositivePay file Creator - QB Online  app.  It supports well over 100 bank file formats and you can create your own custom file formats as well, both CSV ad TXT.

2 replies

M
MirriamM
February 24, 2020

Welcome to the Community forum, @WW Accounting.

 

To import bank transactions into your QuickBooks Online account, your CSV file must be formatted correctly to successfully import it. 
 

Here are the things that you need to check:

  1. QuickBooks has 3 fields: Date, Description and Amount to import bank transactions. Some UK banks provide .CSV transactions in 3 columns, and others in 4 columns (separating Amount into Debit and Credit fields). Both formats work for QuickBooks, if fields are mapped correctly.
  2. Mandatory fields should be filled in. For Amount fields with no value (normally happens to 4-column .CSV files), enter 0 (zero).
  3. Remove all symbols in the Amount field. For example, currency sign or comma.
  4. If your Amount field is in one column, use the minus - sign  to depict money out rather than brackets ( ).
  5. Remove non-transactional info in the file (ex. account numbers, opening, closing balance).
  6. Save your changes.

Once verified, you can now import bank transaction, here's how:

  1. In the left menu, click Banking and go to the Banking menu.
  2. Choose File upload. If you’ve never connected an account, you can select Upload transactions manually. You can also begin your upload from the Import Data page (select Settings ⚙, under Tools select Import Data, and select Bank Data).
  3. Pick Browse and choose the file you downloaded from your bank. If you haven't downloaded your CSV file yet, follow the onscreen instructions in the Upload file window to download your transactions and then select the file you downloaded.
  4. Select Open, then select Next.
  5. From the QuickBooks Account drop-down list, select the bank or credit card account then select Next.
  6. Choose a Date, date format, Description, and Account. Note: You can choose 1 column or 2 columns.
  7. Hit Next.
  8. Select the checkboxes of the transactions to import and select Next then Yes.
  9. Select Let's go! when the Import completed notification appears.

To learn more about importing bank transactions, check below articles:

If you have any other follow up questions, let me know by commenting below. I'm here for you. Have a wonderful day ahead!

BigRedConsulting
BigRedConsultingAnswer
September 30, 2020

To create positive pay files using data from your QuickBooks Online company, use our BRC PositivePay file Creator - QB Online  app.  It supports well over 100 bank file formats and you can create your own custom file formats as well, both CSV ad TXT.

G
gambaj
March 8, 2023

Hello,

 

Do you provide assistance for the Desktop version of QB Pro?

 

We need to create a "check issue/void" file for the bank in either csv delimited or fixed width to accommodate a positive pay system to upload to our Bank for each check run.

 

M
MirriamM
March 8, 2023

Welcome to the thread, @gambaj.

 

In QuickBooks Desktop (QBDT), you can run and export the Check Detail and/or Audit Trail report for voided checks for your check transactions for the bank.

 

To run and export the Check Detail report, here's how:

 

  1. Go to the Report menu at the top.
  2. Select Banking.
  3. Choose Check Detail.
  4. Set the necessary filters.
  5. Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet. 
  6. If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
  7. When you’re ready to export, select OK.

 

To run and export the Audit Trail report for voided checks, here's how:

 

  1. Go to the Report menu at the top.
  2. Choose Account & Taxes.
  3. Select Audit Trail.
  4. On the report screen, click Customize Report.
  5. Go to the Filter tab and search for Transaction type.
  6. Choose Checks and hit OK
  7. Filter the dates.
  8. Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet. 
  9. If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
  10. When you’re ready to export, select OK.

 

You can also check this article to guide you in generating reports in your QBDT to show the information you need: Customize reports in QuickBooks Desktop.

 

For future reference, here's a great resource about the best practices when reconciling: Learn the reconcile workflow in QuickBooks.

 

Please let me know if there's anything else I can do for you. I'll be standing by for your response. Have a great day.

Terms & ConditionsAccessibility statement