How To Upload Credit Card Information In Quickbooks

How to Import Credit Card Transactions into QuickBooks Desktop?

Modified on: Friday, 9 Apr, 2021 at 2:09 PM

Import Credit Carte du jour Transactions into QuickBooks

Import Credit Card Statements from Supported File Formats directly into QuickBooks Desktop using SaasAnt Transactions (Desktop) - #ane user rated and Intuit trusted bulk data automation tool congenital exclusively for QuickBooks.

SaasAnt Transactions (Desktop) supports QuickBooks Pro, Premier, Enterprise, and Accountant Editions.

Y'all can download the free trial of the software directly from the SaasAnt Website. Follow this commodity for detailed installation instruction. You can easilyimport credit card transactions into QuickBooks Desktop.

Steps to Import Credit Card Transactions into QuickBooks Desktop

Importing with SaasAnt Transaction is a cakewalk with our simplified and powerful Import wizard. Simply follow a uncomplicated 3 step process to majority import your file data to QuickBooks.

Click the Import push in the Dashboard screen or Import option from the File card in the menubar to navigate to the File Selection screen of the Import Wizard(Step ane).

• Step one - File Selection: Select "QuickBooks Transaction Blazon" as "Credit Card Statement". "Select Your File" - You can either click "Browse File" to browse and select the file from the local reckoner folder or click "Sample Templates" to navigate to SaasAnt sample file in local.
• Stride 2 - Mapping:Ready the mapping of the file columns respective to QuickBooks fields. This footstep will be automated for you if you use the SaasAnt template file. Download Sample Template file.
• Stride three - Review & Import: Review your file data in the Review Grid screen and click "Ship to QuickBooks" to upload your file data to QuickBooks.

More detailed instruction of the steps are available in this commodity.

How does it piece of work?

Allow's assume that nosotros accept a file which contains following credit card statement.

Appointment	Description	Amount
23/12/18	Buy of Phones	-100
23/12/18	Nib Payment	900

Credit bill of fare statement argument has Charges for Vendors and Credit/Refunds from Vendors.To import Charges(Expense) and Refunds ,we demand to mention

i. Credit Menu Account

2.Expense Accounts

three.Client or Vendor Names

Let's modify the file to add above details.

Engagement	Description	Amount	Credit Card Account	Account	Payee
23/12/18	Buy of Phones	-100	Amex	Uncatergorized Expense Business relationship	John
23/12/xviii	Card Payment	900	Amex	Phone Expense Business relationship	Phone Visitor 1

Now nosotros can import this file using SaasAnt Transactions (Desktop).

• If the transaction has POSITIVE Corporeality, information technology will exist considered as Credits/ Refunds.
• If the transaction has NEGATIVE Amount, it volition exist considered equally Expense /Charges .

If the file has carve up columns for Credit and Debit, It tin can be directly mapped too.

Statement Line equally Credit Carte du jour Charge

Statement Line as Refund

Mapping QuickBooks Fields

Field Proper name	Format	Description
Statement No	Text (Max Length: eleven Characters)	Statement No for Credit Card Credit Transaction
Date *	Date	The date when this transaction occurred.
Credit Card Account *	Reference Text	Name of the Credit Account for this transaction. Name or Account Number tin exist given.
Payee *	Reference Text	Reference to Vendor,Employee or Customer. Name , Account Number or Custom Field Value can be given.
Account *	Reference Text	Reference to the Expense Account Proper noun or Income Account Proper noun associated with the transaction. Name or Account Number can be given.
Amount *	Decimal	The amount of the transaction. NEGATIVE Amount will be considered as Expense /Charges POSITIVE Amount will be considered as Credits/ Refunds
Credit * *	Decimal	Refund Amount
Debit * *	Decimal	Expense Amount
Memo	Text (Max Length: 4095 Characters)
Customer	Reference Text	Name of the client associated with this expense or refund.
Billable Condition	Boolean ( True / False)	Is the customer to be billed ?
Class	Reference Text
Currency	Currency Code	3 Letter Currency Lawmaking Ex: USD,EUR
Commutation Rate	Decimal

All (*) marked fields are mandatory.

Import Settings

A host of powerful customisations for your file data is available with Import Settings. This is bachelor in the  Step three: Review & Import screen or directly under "Edit" Menu in the menubar. Some of the very useful settings for transaction includes:

• Find Matching Transactions in QuickBooks by: Identifier to locate existing transactions in your QuickBooks.
• Activeness When a Matched Transaction Establish: If an existing transaction is institute for the to a higher place setting identifier then the corresponding action to be taken. You tin choose to Indistinguishable/ Ignore/ Update/ Append existing transaction in your QuickBooks.
• Pre-Import Validation: Validate the consummate file earlier importing to QuickBooks. Past turning this setting ON, file rows volition exist imported just afterwards cleaning up all the issues in file. This choice however will delay the import.

More than details near the settings related to Automatic cosmos of Items, Assigning reference number from the file, etc are bachelor in this article.

FAQ's

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

• Will your awarding support Multi Line Transactions?

            Yes. Information technology will.

• I made some mistakes in the Import and my QuickBooks reports got corrupted. Is at that place any way to undo or revert my Import?

            It is possible to undo the import completely/ partially with the Delete feature.

• Does your app support taxes?

            Yes. It does.

• My file has some specific date format. I don't desire to modify the file. Volition your product support all appointment formats?

            Yeah. You can select the specific date format as per your requirement in the import settings.

• Do you have any sample templates?

            Yep. We exercise have. Sample Template

• What are the file types supported by your application?

            TXT, CSV, XLS, XLSX etc. Supported File Formats

• How do I study the issues if I am stuck?
  Experience free to drop an email to back up@saasant.com

Source: https://support.saasant.com/support/solutions/articles/14000096939-how-to-import-credit-card-transactions-into-quickbooks-desktop-

Posted by: howardbesse1992.blogspot.com

Share this post