This object is in archive!
Quickbook's reports have different sales totals
Solved
The amount in QB is different than the YTD sales in InflatableOffice.
The amount in QB is different than the YTD sales in InflatableOffice.
The same problem
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
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
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
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
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.
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.
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.
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.
Replies have been locked on this page!