Export Transactions for use with online check printing portal

KDuckworth · ‎June 11, 2020

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.

BigRedConsulting · ‎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

View solution in original post

BigRedConsulting · ‎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 · ‎June 11, 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 Account

Payee

Transaction Date

RefNumber

Memo

Address Line1

Address Line2

Address Line3

Address Line4

Address City

Address State

Address PostalCode

Address Country

Vendor Acct No

Expenses Account

Expenses Amount

Expenses Memo

Expenses Class

Expenses Customer

Expenses Billable

Items Item

Items Qty

Items Description

Items Cost

Items Class

Items Customer

Unit of Measure

Items Billable

Currency

Exchange Rate

Checking

Sunoco

01/10/2020

100

Monthly Gas

Sunoco

1 Main Street

Newtown

NJ

12345

USA

Fuel

25

John's Car

Checking

Sunoco

01/10/2020

100

Monthly Gas

Sunoco

1 Main Street

Newtown

NJ

12345

USA

Fuel

50

Karen's Car

Checking

Michael's Fine Cabinetry

30/09/2020

101

Unitel

12 Smith Ave

Anywhere

NH

22222

USA

Cabinets

10

Cabinets

150

Baker, Chris:Family Room

Y

Topics

Training

Community

Resources

Export Transactions for use with online check printing portal