Skip to main content
K
KDuckworth
June 11, 2020
Solved

Export Transactions for use with online check printing portal

  • June 11, 2020
  • 2 replies
  • 0 views

Since everyone is working remotely I need an online upload option for sending a csv to a check processor for printing and mailing checks.  They have the ability to issue a single check with several line items of details on line items for this invoice.  I need to see if Quickbooks Enterprise desktop version can get an exported file that is broken down with information similar to this image which was doctered up based on the processor upload specs.  The current top section is being exported today, the export needs is the needed format.

Best answer by BigRedConsulting

I downloaded your file and it appears blank when I try to view it.

 

QB won't create CSV files, but this might be something we can build into our BRC PositivePay file Creator - QB Desktop , which already supports three check printing formats:

- BancFirst - Integrated Payables

- Chase - PWS Check Print - Quick CSV

- JP Morgan Access Checks - Check Print

 

What's the check processor?  If you can get their requirements to us -  I can let you know if it's something we can add to the app.  Start here to send a request: BRC Support Request  

2 replies

BigRedConsulting
BigRedConsultingAnswer
June 11, 2020

I downloaded your file and it appears blank when I try to view it.

 

QB won't create CSV files, but this might be something we can build into our BRC PositivePay file Creator - QB Desktop , which already supports three check printing formats:

- BancFirst - Integrated Payables

- Chase - PWS Check Print - Quick CSV

- JP Morgan Access Checks - Check Print

 

What's the check processor?  If you can get their requirements to us -  I can let you know if it's something we can add to the app.  Start here to send a request: BRC Support Request  

Fiat Lux - ASIA
Fiat Lux - ASIA
June 12, 2020

@KDuckworth 

Another option, utilize one of these tools to export your Checks data to CSV

https:// transactionpro.grsm.io/qbd

https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The standard output should be like this and you may set filters if required prior to hit the export button 

Bank AccountPayeeTransaction DateRefNumberMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerUnit of MeasureItems BillableCurrencyExchange Rate
CheckingSunoco01/10/2020100Monthly GasSunoco1 Main Street  NewtownNJ12345USA Fuel25John's Car             
CheckingSunoco01/10/2020100Monthly GasSunoco1 Main Street  NewtownNJ12345USA Fuel50Karen's Car             
CheckingMichael's Fine Cabinetry30/09/2020101 Unitel12 Smith Ave  AnywhereNH22222USA       Cabinets10Cabinets150 Baker, Chris:Family Room Y  

 

Terms & ConditionsAccessibility statement