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

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Welcome
Login  Sign up

Flexible Date formats supported by SaasAnt Transactions (Online)

SaasAnt Transactions (Online) allows users to enter multiple date formats for importing files as per their convenience. Each country or each Firm uses a different date format in their QuickBooks import file. A user or an organization can change a particular date format from one document to another. 

 

Let’s take a look at flexible date formats supported by SaasAnt Transactions (Online)

 

Table of Contents

  • Why to Use a Specific Date Format?
  •  How is the Date format in QuickBooks handled in SaasAnt Transactions (Online)?
  •  How to Find Out the Incorrect Date Format?
  • FAQs


Why to Use a Specific Date Format?


To avoid conflicts with your given date format in the file, you are requested to use the same date format as per your file. 


Example: (dd/mm/yy) 


Note: We have  22 numbers of date format available in our application settings. 


If you are new to SaasAnt Transactions (Online), please go through the below steps to use a specific date format. 

 

Go to Gear Icon

Select Import Settings

Click on General on the left pane


 

The one which we interested currently is “Date Format”.


Date format in QuickBooks 

The drop down has several date formats as below. You can select the one as per your need.


DD-MM-YYYY  (E.g. 15-01-2016)

 

DD-MM-YY  (E.g. 15-01-16)

 

MM-DD-YYYY  (E.g. 01-05-2016)

 

MM-DD-YY  (E.g.: 01-15-16)

 

MM-DD-YY  (E.g. 01-15-16)

 

YYYY-MM-DD  (E.g. 2016-01-15)

 

YY-MM-DD  (E.g. 16-01-15)

 

DD-MMM-YYYY (E.g. 15-JAN-2016)

 

DD-MMM-YY (E.g. 15-JAN-16)

 

MMM-DD-YYYY (E.g. JAN-15-2016)

 

MMM-DD-YY (E.g. JAN-15-16)

 

Don’t forget to “Save” the settings.

 

How is the Date format in QuickBooks handled in SaasAnt Transactions (Online)?

 

We don’t want to make any assumptions about the date formats. Because it is difficult to arrive at the conclusion that “01-02-16” is January 2, 2016, or February 1, 2016. So we have provided the settings to capture your date format.


How to Find Out the Incorrect Date Format?

 

If you have already imported your transactions using SaasAnt Transactions (Online) and found that the date is wrong in your QuickBooks, you need to change your date settings.


It is very common that you might have missed this setting and tried to import it. But we know that your file has a different date format.


So you can see a message given below on your screen- 


 change quickbooks date format


SaasAnt Transactions (Online) warns you and asks you to open settings to change the date format.


You can change the date format or upload it.


FAQ's

 

Most of us would have some questions while moving data to your QuickBooks Online. Some of them for your reference below:

 

I want to import Invoices with Invoice Numbers into QuickBooks from File. Is it supported?

Yes. It is supported. More Info...

 

Will SaasAnt Transactions (Online) support QuickBooks Multi-Line Transactions?

Yes. It will. More Info...

 

I made some mistakes in the mapping. Your application imported wrongly. So my QuickBooks file got corrupted. Is there any way to undo or revert?

Sometimes it happens due to the wrong mapping. It is possible to delete the entire transactions which went wrong. Our DELETE feature is the rescue. More Info...

 

I want to import Invoices using SKU's. Is it supported?

Yes. It is. You need to enable a couple of settings while importing. More Info...

 

I want to get an email for each Import. Is it possible?

Yes. It is. You need to enable a couple of settings while importing. More Info...

 

Are there any specific Import Settings?

Yes. We do have a couple of important settings for import. More Info...

 

Does SaasAnt Transactions (Online) support taxes?

Yes. It does. Tax model for U.S Companies.

 

I don't want to create products automatically for my invoices. I can't create products before each upload. Is it supported?

Yes. It is. You need to enable a couple of settings while importing. However. you can control this behavior. More Info...

 

My file has some specific date format. I don't want to change the file. Will your product support all date formats?

Yes. You can select the specific date format as per your requirement. More Info...

 

Do you have any sample templates?

Yes. We do have. Sample template for Imports.

 

What are the file types supported by SaasAnt Transactions (Online)?

SaasAnt Transactions (Online) supports txt, csv, xls, xlsx files.

 

How do I report the issues if I am stuck?

Feel free to drop an email to support@saasant.com




Did you find it helpful? Yes No

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