Ph: +1 (619) 377-0977 (9 A.M to 5 P.M EST)

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Login  Sign up

File Format Guidelines for SaasAnt Transactions (Online)

To import your data seamlessly, SaasAnt Transactions (Online) needs to understand your data. So that we have decided to follow one GOLDEN Rule for the QuickBooks import file.

Golden Rule

The first line or first row of your file will be treated as your File Header.

Some of you might have experienced that “SaasAnt Transactions (Online)” did not show your file headers in the field mapping screen properly. This will happen only if your import file does not have HEADERS in the first row. This is a common issue when we receive a file from any 3rd party software.


Wrong Format

Below is an example of the wrong file format. The file header is not aligned properly.

wrong file format to import to quickbooks


Just delete the unwanted rows or lines from your file and make the proper file headers as your first line.

Right Format

The below example is the right file format and is ready to import into QuickBooks Online.

right file format to import to quickbooks

Supported File Types


1.  Excel Work Books (.xls, .xlsx)

2.  CSV Files (Comma Separated, “|” pipe separated)

QuickBooks File Formatter


It is very common that you may have a file to import into QuickBooks that may not agree with our guidelines. Our File Formatter feature will help you to convert files to the desired format.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.