Quickbook's reports have different sales totals

InflatableOffice shared this problem 5 years ago
Solved

The amount in QB is different than the YTD sales in InflatableOffice.

Best Answer
photo

Three possible reasons of why there is a difference:


1. returns/refunds/chargebacks are not sent to QB. If you delete a

payment or enter a negative payment in IO, you'll need to manually

update QB


2. The YTD sales in IO will include the upcoming event totals, not the

payments. Depending on if you are Cash vs Accrual, QB either only shows the payments (cash) or it is including the

invoice totals (accrual). It also probably doesn't have all the same events as IO

only sends events to QB if there is a payment on it or it is Confirmed

or Complete. You can adjust these settings by going to Settings->Statuses.

3. Check the QB Log by going to Settings->Quickbooks and clicking View Queue and View Log at the top-right. You'll see items that have not gone in and that have failed.


You may want to run a custom report out of IO by going to Leads,

setting the filter to match what is in QB, then click Reports to view

the data. See how to setup custom reports

You'd filter it by setting the preset filter to Has

Payment, the date range, and un-check all status' except Confirmed and Complete.


See more details on QB integration

Comments (3)

photo
1

Three possible reasons of why there is a difference:


1. returns/refunds/chargebacks are not sent to QB. If you delete a

payment or enter a negative payment in IO, you'll need to manually

update QB


2. The YTD sales in IO will include the upcoming event totals, not the

payments. Depending on if you are Cash vs Accrual, QB either only shows the payments (cash) or it is including the

invoice totals (accrual). It also probably doesn't have all the same events as IO

only sends events to QB if there is a payment on it or it is Confirmed

or Complete. You can adjust these settings by going to Settings->Statuses.

3. Check the QB Log by going to Settings->Quickbooks and clicking View Queue and View Log at the top-right. You'll see items that have not gone in and that have failed.


You may want to run a custom report out of IO by going to Leads,

setting the filter to match what is in QB, then click Reports to view

the data. See how to setup custom reports

You'd filter it by setting the preset filter to Has

Payment, the date range, and un-check all status' except Confirmed and Complete.


See more details on QB integration

photo
1

You may also want to look at your Item List. If you charged any additional fees such as "Delivery Fees" or "Fees", IO does not calculate tax and Quickbooks may.

photo
1

Good point. Tax on delivery, staffing, and rentals is based on your settings and is calculated by Taxcloud and can vary from area to area. Quickbooks may calculate tax slightly differently.