Reconcile Multiple Credit Cards in QuickBooks Online

by James Antonio

To begin with, reconcile multiple credit cards in QuickBooks is an important step when it comes to maintaining good bookkeeping standards. When credit cards are reconciled, users can ensure that particular credit card activity is in sync with the credit card statement of the QuickBooks account.

Reconcile Multiple Credit Cards

Read on to know why reconciliation is easy and how you should do it.

What is Reconciling of Credit Card in QuickBooks Online?

In order to reconcile multiple credit cards account, you need to add the ending statement balance. After that, you can match your particular transaction with the ones in your QuickBooks account.

When all the transactions show as CLEARED on the particular statement, then the QuickBooks cleared balance will be the same as your statement balance. Now your account gets reconciled.

Furthermore, while reconciling credit cards, there are few important points to be considered:

  • Find out the transactions that are missing- In case the transactions on the statement are missing from your QuickBooks account, then you will need to add it prior to reconciling the account.
  • Locate duplicate transactions- By examining the transactions for over a month which was not displayed on the bank statement, you can identify the transactions which should never be in your particular QuickBooks account.
  • Identify incorrect amounts- In case the transaction is the same but the amount differs in the bank statement and QuickBooks, then such particular account will never be reconciled.
  • Look for deceitful charges- If there are any changes on the particular bank statement which are not found in QuickBooks, you should check if the charges are genuine or not.

How to Reconcile Multiple Credit Cards in QuickBooks Online?

In bookkeeping, reconciling your credit cards is a vital step to make sure that the credit card performance in QuickBooks is similar to the activity of the credit card statement itself.

QuickBooks enables you to reconcile only two credit cards in a combined bank statement. The first thing you are required to do is set up your bank account. The first bank account you need to set up as a parent and the other bank account at sub-account.

Additionally, you can also do a force reconciliation. For this purpose, you will need to reconcile the particular account and then make a new transaction adjustment.

The following steps will show how both the ways:

Method 1: Building a Bank Account as a Parent while the other account as a particular Sub-account

Step 1: Select the Transaction or the Banking option displayed on the screen.

Step 2: Then choose the Connect option or select the Add Account button if you have not created an account due to any reason.

Step 3: Look for your bank.

Step 4: Select the Continue button.

Step 5: Then the next step is to add the particular username along with the password that is used for the bank website.

Step 6: Now select the type of account that you want to add.

Step 7: Select the date range in order to download the transactions. Few banks allow you to download the transactions of the last 90 days. Some banks allow you to download transaction of the last 24 months.

Step 8: Next, choose the Connect option.

Note: When you are connected to online banking, you must ensure how the downloaded transactions are shared with you by the bank. In case your particular transaction is downloaded to any one single account then it is possible to connect it with the parent account only. However, in case the transactions are downloaded to individual accounts, it is possible to connect the sub-accounts instead of the parent account.

If your opening balance is wrong, then it is highly recommended to delete the balance. You can delete the balance with the help of the instructions given below:

Step 1: Select the Accounting menu seen on the left side of the panel.

Step 2: Then select the Chart of Accounts option.

Step 3: Next, select the account.

Step 4: Select the View Register.

Step 5: Choose the Edit button and then erase the opening balance.

Step 6: Click the Save button.

Once all the steps are done, it is compulsory to reconcile the parent account. When you do so, all the particular transactions will increase in the sub-accounts.

Method 2: Reconcile the Account and then add the required adjustment for the difference

Step 1: Select the Gear icon.

Step 2: Choose the Reconcile button in the Tools section.

Step 3: Select the Account.

Step 4: Add the Ending Date and Balance.

Step 5: Select Start Reconciling and then click Save for later.

Step 6: Select Finish now and then choose the Add to adjustment and finish.

Here we have shared about reconcile multiple credit cards in QuickBooks Online. This article will also guide the process of reconciling credit card payments, multiple credit cards, and partial payments.


Need Some one on one QuickBooks Assistance?


Why users need to Reconcile their Credit Cards?

Users need to reconcile their credit cards, users ensure that the credit activity is in sync with the credit card statement.

How to identify the Transactions which must not be in QuickBooks account?

By determining the transactions for over a month that was not displayed in the bank statement. It is possible to identify the transactions that are missing QuickBooks account.

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

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.

Dancing Number

Kindly Provide The Following Information To Download The Dancing Numbers.

X





    Top