Download American Express Credit Card Activity For QuickBooks

Here is the procedure given which provides the set-up assistance to download the AMEX credit card transactions. When set up […]

Here is the procedure given which provides the set-up assistance to download the AMEX credit card transactions. When set up is done it’s easy to get the transactions of the business. All the charges of the user’s credit card like office supplies, inventory charges, phone& internet bills, restaurants, etc. will get downloaded in the QuickBooks which will make easy to manage the expenses for the user.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

Steps to Download American Express Credit Card Activity For QuickBooks

Now, Here Are The Steps Given To Complete Prior To Download The transactions From American Express

  • Create Backup Copy: User should always create the backup copy of the QuickBooks file. By doing this if anything goes incorrect, they can start over.
    Keynote: Activities can be synchronized or imported to QB only once to a company file. However, some banks have the ability to release the activity on their side, so that the user is able to download it if required.
  • Create a New Credit Card Account: The QuickBooks Chart of Accounts will require a new Credit Card Account which is known as American Express.
  • Now, open Chart of Account in QuickBooks.
  • After that, navigate to the left corner in the bottom & hit on the down arrow at the bottom left next to Accounts tab & the window Add New Account: Select Account Type will open.
  • Click continue option after selecting the credit card.
  • A new window will appear& type Account Name: American Express, Account description: if the user would like to add more information about the AMEX account, Credit Card Account Number.
  • Now save.
Download American Express Credit Card Activity
  • Now add a new Credit Card Account to the Chart of Account in QuickBooks
  • Create American Express Online Account: If the user has setup the AMEX online account previously, this is the right time to do that. By doing this, user can log in and view or download all the transactions, the statements, and can make online payments and using the bank feed to download the transactions to QuickBooks by a Web Connect or Direct Connect alternative.
    Here is the login link given for your kind reference: https://global.americanexpress.com/login?inav=iNavLnkLog
  • First, Go to the website above.
  • Now, Hit on the Create New Online Account link highlighted below:
Download American Express Credit Card Activity
  • Now, user is required to follow the three-step process to set up the American Express Online account.
  • Here, Add the American Express Account Number.
  • At this point user is required to add the 4 digit CVV number (Card Verification Value) on front of the card.
  • Now, Create the username/ID and Create the password.
  • Process is complete at this point.
  • User can take the help from the below given screenshot.
Download American Express Credit Card Activity
  • Select Preference in QuickBooks Accounting Software: While user is ready to see the transactions. There are two bank feed options given which are classified as Classic mode or Express mode.
  • Classic Mode (original) to see the bank feed transactions in the Account Register. Able to make Aliases.
  • Express Mode & the bank feed entries are watch from a Transaction List.
    These modes can be used vice versa via switched on the Preferences menu, Checking, Company Preferences. This should be done in Single-user Mode and this will be a nice idea to make sure that QuickBooks® has the latest release. User can create their preferences and can turn back to the other mode, whenever they choose.
Download American Express Credit Card Activity

There is a point to know while you make your choice: As you can see the Express mode provides you the feature to make rules. However, these rules are unavailable in the Classic mode. Under the Classic mode, user can create a nickname for every universal kind of entry, but these choices will be disappeared in the Express mode.

Downloading Alternatives Retrieving Transactions

There are two connection options which will the user to pull their entries from American Express. Another option is Direct Connect. Using Direct Connect your QuickBooks accounting software is synchronized to the AMEX & the entries are downloaded directly into QuickBooks, No file to download, save and upload to the company file. These options are not difficult to do, but there might be some fees is imposed to it because of the other functions as bill payments & bank transfers. Below are few steps mentioned for setting up the connection:

Web Connect

Setting up the bank feed for the AMEX Account:

  • In QuickBooks software, there are 2 places to open setup bank feeds:
  • Navigate to the Banking Menu -> Bank Feeds ->Set Up Bank Feed for the Account in the opened AMEX credit card account.
Set Up Bank Feed for the Account

Hit on the Setup Bank Feeds in the opened American Express Account.

  • There will be a notification where user will enter the AMEX online account’s username & password which user has created before.

There is the two-step process which is useful for the Web Connect:

Step 1: Transactions Export:

There are two transactions export options. The entries are exported in the QB files which must be save to the relevant place in the system.

  • First option is to export the file either directly from the AMEX online account, after log into the account.
  • Second option is to export the file from within QuickBooks, once the set-up is done to the bank feed for this account.
  • Now, navigate to the Bank Feed Center, select American Express, choose Download Transactions, at this point user is required to do the log in with the username & password.

Distinct banks/credit card firms allows the user for the dissimilar number of entries to be load at a time along with the few which allows for a date range to be entered. Normally, this would be 30, 60 or 90 days the highest worth of entries.

Step 2: Import Transactions:

The (.QBO file) into QuickBooks accounting software.

In the QuickBooks accounting softwarein the Banking Menu, navigate to Bank Feeds & scroll right & click Import WebConnect File.

  • QuickBooks will ask the user to select the downloaded (.QBO file) which is saved at the system.
  • Now open the file.
  • Select the Credit Card Account (American Express) where the transactions will be imported to.
  • A pop-up will state that QuickBooks accounting software is successfully imported the entries.
  • Now, ready to go to Bank Feeds Center to control the entries.

User Needs To Be Sure That They Have Completed The Steps Above Under “Steps To Complete Before Downloading Transactions From Amex“. Also, User Can connect with the AMEX to see about turning on Direct Connect for the American Express account.

  • First, navigate to the Banking menu in QuickBooks.
  • Now, roll down to the Bank Feed & to the right Bank Feed Center to download the newest entries into QuickBooks.
  • Here at this point, in the option of Bank Feed Center, in the list of Accounts make the selection of the AMEX Account which is the account,user wish the transactions to get synchronized in the QuickBooks software.
  • Select the option of Download Transactions/ Transaction List
  • Here at this point select the Synchronize option & then select Sync this account.

Hit on the icon which appears in the end part of the online banking window labeled AMEX Quick Statement. A Classic Mode Account Register will open, and the user can create one. Or, if the user chose the Express Mode account under preferences then a Transaction List will get open. Now, user can add rules which can be viewed in this mode.

Just allocate the account, the customer name and/or class (if applicable), hit ok and the reports will now have the detail which is required by the user. If the user has purchased from the vendor in the past, these details will be auto-feed in QuickBooks for the user. User is just required to review the details and hit the Ok option. As this is the quicker process along with that connection, there is no download file to export and then to import.

Entering Credit Card Transactions in QuickBooks Accounting Software

Working to match entries: While importing or synchronizing the transactions, the Bank Feed groups the transactions as matched/unmatched or renamed. QuickBooks will try to match the entries to the identical transaction which is set up in the AMEX Account register already.

  • QB will naturally save the transaction, if there is a match.
  • QB might try to use the rules to contest, if there is not an exact match.Here incorrect matches will be adjusted to make a complete match by altering the rule or generating a new rule.
  • If no matches then, user is required to enter manually in the QB. User can make a new rule, so that next time user is able to get the same kind of transaction, QB can use the rule to make a match. Once the transactions are in the register Make sure you don’t skip this step.
  • Now, open every transaction, one at a time.
  • Here, enter an account and memo and class
  • At this step, click Save and close and navigate to the upcoming transaction.
  • And finally hit on done. Hit through any message which appears if the remaining entries in the screen have already been accounted for.

Delete Transactions

Still there might be the entries which user doesn’t wish to enter.

  • Express Mode: There is an option in the lower left margin choose items to remove.
  • Classic Mode: While the user leave the window of the transaction &return to the online banking screen- in the lower right margin of the window remove last left transactions.

Here Are Few Tips On Managing The Transactions Of Credit Card

  • First Set-Up: User will want to enter only unpaid entries. This is presumed the entries which are already been accounted for in QuickBooks. For help in this step, there is a QB support team which is reachable via phone and email.
  • For Small-scale Trade: In numerous small-scale trades, credit card charges do not have the list of packing, receipts, PO or any other documentation for the bookkeeping to refer in the expense categorization.
  • Using Nick Names in Classic Mode: A nickname is a common name like Meals to assist to categorize all the restaurants or Gas to categorize the numerous non-identical gas stations that the company may purchase from. However, it’s a superior idea to put the supplier name in the memo field of every entry. The reports will be extra meaningful and the name of the list will persist attainable. For payments to payees that user use regularly, go ahead and retain the name in the “purchased from” field.

Reconciling Your Credit Card Account (It’s Recommended Doing Every Month)

Reconcile the credit card account prior to make the payment this works same as the reconciliation of the bank account.

Below are few steps mentioned to do the reconciliation of the Credit Card Account:

  • First, navigate to the Banking Menu
  • And then, select the “Reconcile” option
  • Here, select the suitable AMEX credit card account
  • After that, enter the ending balance from the statement of the credit card
  • Now, user is required to mark all transactions which are cleared
  • Hit on the “reconcile now” option if, there is zero difference.

Now, at this stage QB will generate the payment for the user.

Here are just two more steps to complete before you are done:

If you are making a partial payment

Create a bill: Enter a bill for a payment to be made later, if you are not paying the balance in full. Then, the reconciled balance is move to AP.

Change the payment entry to reflect a partial payment

  • Navigate to the Account Payable Summary
  • After that, Drill down on the credit card supplier
  • Now, find the transaction which was just created and swap to the amount which you aim to pay.

If you use credit cards to charge the business expenses, this is one of the QuickBooks software features that you should not live with out. You can always reach out to us without any hesitation in case you want any further assistance at Dancing Numbers Experts.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Close X
Call Now+1-800-596-0806
Top