Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months

2 replies

Fiat Lux - ASIA
Level 14
June 5, 2022

What file format does your bank require? If it's CSV/XLS, you can use the exporter tool as a workaround to generate files similar to Positive Pay systems at US-based banks.

June 5, 2022

@Fiat Lux - ASIA wrote:

What file format does your bank require? If it's CSV/XLS, you can use the exporter tool as a workaround to generate files similar to Positive Pay systems at US-based banks.


Thank you!  Our bank accepts CSV file format.  How do I export the payments in CSV?

Fiat Lux - ASIA
Level 14
June 5, 2022

Before beginning, ask the bank for their specific layout requirements for the file. Then utilize this exporter tool and you can find a certain guideline in the Knowledge Base. Use "Positive Pay" to find the article for your reference.

https://transactionpro.grsm.io/qbo

 

MJoy_D
QuickBooks Team
June 5, 2022

I can help you with creating a file with the correct format that can be imported in QuickBooks Online (QBO) successfully, @a-shepherd-about.

 

Supported file types are CSV and QBO file. First, go to your bank's website and follow your bank's instructions for how to download a CSV or QBO file of your transactions to your computer. Once done, check the format of the file. You can choose either a 3-column or 4-column format. 

 

A 3-column format must have a Date, a Description and the Amount of the transaction. A 4-column has a DateDescriptionCredit, and Debit column.

 

For your visual reference of the formats I've mentioned above and other things to check, in case you'd see an error message when you import, check out this article: Format CSV files in Excel to get bank transactions into QuickBooks

 

From here, you can now upload or import the file to the QBO account: Manually upload transactions into QuickBooks Online.

 

Once the transactions are added to your account, match and categorise these supplier payment transactions: Categorise and match online bank transactions in QuickBooks Online.

 

Then, reconcile them to make sure your books are correct and no duplicate transactions exist.

 

I'm always here if you need more help with your supplier payment file. Let me know in the Reply section below. Have a great rest of the day!