CYBER MONDAY SALE 70% OFF QuickBooks for 3 months*   Ends 12/5

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll

Reply to message

View discussion in a popup

Replying to:
Anonymous
Not applicable

Reply to message

On issue is that the transaction types in the IIF file are wrong.  A "PAYMENT" is a customer payment on account and will always use an A/R account on the SPL line, and never "Unknown", unless you've named your A/R account "Unknown".  Also, each Payment should use a known customer name in QB.

 

It is unlikely that your bank will have any knowledge of your PAYMENT transactions, which won't use your bank account directly.  PAYMENTS should not be in an IIF file from a bank.

 

Also, unless you have named your bank account "[removed]-Demand Deposit" then the remaining transactions, which can be imported, will be imported into that account.  Really, the bank should ask you what your bank account is called and put that in the IIF file.

 

QB is auto-creating new accounts when they are encountered in the file.  Since they're not explicitly added, QB adds them using the default type, which is bank.

View solution in original post

Need to get in touch?

Contact us