cancel
Showing results for 
Search instead for 
Did you mean: 
tuckerkistner
Level 2

Automatic CRM Messing Up Reconciliation

I have QuickBooks simple start. 

 

I recently integrated my CRM (Wodify) with Quickbooks, so my income is automatically categorized into my profit/loss statement into proper categories. For context, I am a gym owner the kinds of income I receive are membership revenue, supplement sales, and merchandise sales. The integration automatically categorizes this so I don't have to.

 

However, when I go to "review transactions" I still have the option to categorize the income. So, when I categorize it, it shows the income as doubled (i.e. it counts it twice). I was told to exclude these transactions, but when I went to do my monthly reconciliation, there is a large difference. It's like none of the income was categorized since I excluded those transactions... But it shows it on the profit and loss statement. I don't know how to remedy this.

1 Comment 1
Rasa-LilaM
QuickBooks Team

Automatic CRM Messing Up Reconciliation

Thank you for turning to the Community about your reconciliation concern, tuckerkistner.

 

We'll have to match your downloaded transactions to the ones recorded in QuickBooks Online (QBO). Then, review the opening balance of the account and make sure it's the right one to ensure a smooth reconciliation process.

 

QuickBooks will look for matches, rules, and recognized transactions in your bank data. You can compare the bank feed transactions to existing ones in the online program as you review them. This links them together so you don't get duplicates. Here's an article that goes into detail about the process: Categorize and match online bank transactions in QuickBooks Online

 

After you've matched the entries, double-check the opening balance for the account you're reconciling. Occasionally, transactions that were pending when you opened the account are not included in the opening balance. Follow these steps to find the opening balance:

 

  1. In your company, head to the Bookkeeping or Accounting menu on the left panel and choose Chart of accounts.
  2. Find the account on the list and tap the View register link to show all transactions recorded.
  3. Search for the opening balance entry and it should have "Opening Balance Equity" in the Account column.ob.png
  4. Take note of the date and balance.

 

If you're unable to enter the opening balance, you can enter one later. Then, compare the opening balance to your actual account. You can compare the two balances by logging into the website of your financial institution (FI). Perform Step 2 in this article up until Step 3 for complete instructions: Fix issues the first time you reconcile an account.

 

Once done, you can reconcile your account. If you come across any discrepancies and other issues, these resources will guide you on how to troubleshoot them:

 

 

Additionally, you can bookmark the Community page in your browser for later use. It includes a list of topics that will help you manage your cash flow, payroll, taxes, and other accounting-related chores more effectively.


Keep me posted below you if have other banking concerns or questions about the product. I'd be delighted to respond to them.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us