Pinterest

How to Reconcile in QuickBooks Online

When your business is operating in multitude of transactions and digits, it’s easy for small mistakes to start accumulating and […]

Voiced by Amazon Polly

When your business is operating in multitude of transactions and digits, it’s easy for small mistakes to start accumulating and in turn causing variability.

If there are dissimilarities between statements that are unanticipated, it’s critical to get to the root of the problem and either unfold the differences or regulate it.

When performing the accounting of a business, it’s utterly important to recognize how to reconcile on QuickBooks Online, one of the most extensively used online accounting tools in the world.

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.

What is Reconciliation?

Reconciliation is an accounting process that notes the similarity and dissimilarity between two sets of records to examine that accounting records are correct and accurate. A reconciliation can assist in disclosing accounting errors and perhaps cooked transactions. To avoid the mismatching of accounts and to further eradicate errors from your financial statements QuickBooks Online comes in the frame.

There are various types of accounts incorporated in a business. It’s essential to carry out reconciliation of the main accounts, such as:

  • Sales and Purchases accounts
  • Inventory
  • Cash account
  • Trade Receivables and Account Payables

As a business, it’s important to stick onto each and every accounting record for the avoidance of slightest errors that are likely to happen. If there is an unknown figure, or a charge that doesn’t equate with your records, this could be an indication of a mistake or fraudulent activity.

How to Reconcile on QuickBooks?

Reconciling on QuickBooks Online is an uncomplicated and efficacious process, permitting you to systematically reconcile your company’s accounting records and examine any significant variances.

Let’s get started with reconciling your accounts:

Step 1: Get Your Financial Statements

For the purpose of reconciling on QuickBooks, firstly you’ll need to have your financial statements ready in hand. These days, the majority of financial statements are sent out online.

Make sure to have each and every accounting statement in proper order before you start the procedure of reconciliation.

Step 2: Reconcile on QuickBooks Online

When you are ready to get moving,

  • Select the gear in the top right of the QuickBooks Online menu.
  • Choose the Reconcile option in the menu. (In case you’re reconciling for the very first time, select Get started to proceed.)
  • Select the account that you wish to reconcile.
  • Enter the necessary data from your financial statement. This information can include:
    • Opening Balance
    • Closing Balance
    • Ending Date
  • Then click 👆Start reconciling. Reconciling on QuickBooks is efficacious because the software is able to do multiple jobs for you. Although, it’s still important that you make sure you are entering all the correct digits and cross verifying every result displayed.

Step 3: Study the Reconciliation Report

Once QuickBooks does the reconciliation, you will be displayed with a report loaded with information.

On top, you will see a short summary incorporating the opening and closing balances, payments, and deposits.

After that, you will see an entire disintegration of all transactions.

Every transaction will display:

  • The date of the transaction,
  • The date it was cleared,
  • The type of transaction,
  • A reference number if applicable, the account, and the payee.

On the right, you will see a green icon that shows whether the transaction was reconciled in the banking feed. Moreover you’ll see sections for either payment or deposit, pointing to the amount of the transaction.

Step 4: Match Payments

Now, you’ll look your bank statement in hand, and can recheck every transaction and make sure that each one reconciles. Once a transaction matches, you can put a check on the right column in QuickBooks.

This marks that transactions are matched. Carry on with this process through the entire statement.

You can also create little edits if needed right within this window. For instance, if the receiver is wrong, you can click on the transaction to enlarge the view and then choose Edit.

Want to UNDO a reconciled transaction? Don’t stress! (In case you’re halfway to reconciling, stay on the page you’re on and skip to step 4).

  • Select Accounting on the left menu.
  • Go to the Chart of Accounts.
  • Figure out the account holding the transaction. Select View register.
  • Select the transaction you want to unreconcile to enlarge the view.
  • If the transaction is reconciled, you’ll see an “R.”
  • Click the checkbox till it is blank. This undoes the transaction from the reconciliation.
  • Click Save.

Once everything has been checked off, you should probably see 0$ in the top right corner where it says Difference.

After that, you can finally click Finish now!

Subsequently, you will have the option to view and save the reconciliation report in its totality.

Reconciling in QuickBooks is this simple, and it ensures that you don’t skip a single transaction or let anything go unnoticed.

Why is Reconciliation Important?

It’s very obvious for accounting errors/mistakes to take place, hence reconciliation is important to look through, over a fiscal period and make certain that all errors are eradicated and reconciled (that is what the name suggests!)

By any chance, if a mistake cannot be appropriately unfolded or reconciled, this could be an indication of massive issues within your business, whether it is mixed up processes or dishonest activity taking place.

It’s simple to presume that these things won’t happen to you or your business, but the bitter pill is that financial fraud is pretty common.

As an accountant or a business owner, it’s your responsibility to stay alert in order to give a wide berth to this risk or notice it as soon as possible to reduce possible damages.

How to Track Your Cash Flow in QuickBooks Online?

  • Talking about cash flow reporting, the first and the foremost thing to do is make sure your books are error-free.
  • Initiate a cash flow forecast. A cash flow forecast assists you in determining how long you can continue business operations.
    • Download the Forecasting Worksheet
    • Run a profit and loss report for the past three months to get an interpretation of your average income and expenses for each month.
    • Run an open invoices report
    • Run an unpaid bills report
  • Optimize your Cash Flow

Step 1: See Which Customers owe You?

  • Start an Open Invoices Report
  • Run a Customer Balance Detail Report

Step 2: Reduce Fixed Expenses.

Large Monthly Expenses are the Easiest to Identify. Reducing them can have a Significant Impact on Available Cash for the Business.

Step 3: See Which Bills are Due?

  • Run an Unpaid Bills Report
  • Run an Expenses by Vendor Report

Step 4: Reduce Your Money Out

  • Recognize Which Lenders to Contact
  • Identify which Tax Agencies to Contact
  • Calculate your Payroll Tax

Step 5: Cut Back on Discretionary Spending

  • Marketing and Advertising
  • Subscriptions and Memberships
  • Meals and Entertainment
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-347-428-6831 or chat with experts.


How to Fix issues the First Time you Reconcile an Account in QuickBooks Online?

Review the starting balance in QuickBooks
Compare the starting balance with your in-hand accounts
Go through your account register
Begin with reconciling process

How to Reconcile an Account in QuickBooks Online?

Examine your starting balance.
You can start matching once you have monthly bank/credit card statement.
Afterwards, you need to thoroughly compare the transactions on your statements one by one.
Examine previous reconciliations.
Now you can make certain amendments to past reconciliations. Changes can imbalance your accounts and other reconciliations.

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

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

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

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.

Book your consultation Book Free Consultation
Close X
Call Now+1-800-596-0806
Dancing Number

We value your privacy and are strongly against any kind of phishing, spam, and malware. We collect your information for our legitimate business purpose only. This information is safe with our in-built security.

X



    Top