File would include check #, $ amount, check date and Payee name on the check.
Hello there, randerson.
I can definitely help you with import your transactions using a CSV file.
When importing a CSV file, the accepted file formats are the 3 and 4 column formats. The 3 column includes the Date, Description and Amount. On the other hand, the 4 column format includes the Date, Description, Credit and Debit.
For more details, you may refer to this article: Import bank transactions from Excel CSV file to QuickBooks Online.
If you'd like to request more flexibility, I'd encourage you to send a message to our product development team requesting that more columns be added. This will make them aware of how you want the program to work. Here's how: http://feedback.qbo.intuit.com/.
If you hand with importing your transactions, just leave comment below. Enjoy your weekend.
To create positive pay files from your QB Online company, use our BRC PositivePay file Creator - QB Online app. If your bank isn't listed, we may be able to add it for you.
Run the Transaction report for the account and date range and export to excel using just the fields Date, Num, Credit, Name. (I memorized this report)
Eliminate the non-check transactions (I sort by NUM and delete the rows I don't need)
Run the Vendor Contact List report and Customize Report with just the fields "Vendor" and "Print on Check as"
Use VLOOKUP to get Payee (=vlookup(A2,[Payees.xlsx]Sheet1!$A:$D,4,0)
Convert formulas to values
Complete your Positive Pay file.