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.
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?
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.
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 Date, Description, Credit,and Debit column.