Limited time only. 90% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
info2197
Level 1

Discrepancy between PST report (cash basis) and bank deposits—PST report shows $2,836.22, bank shows $2,970. Unsure why $133.78 is missing?

Issue: Discrepancy Between PST Report and Bank Statement (May 2025) I’m reconciling my May 2025 transactions for AROKA Contracting Ltd. and noticed a discrepancy between my bank statement and my PST Detail Report (cash basis) from my accounting software. According to my RBC bank statement, I received $2,970.00 in total e-Transfers in May from four clients. However, the PST Detail Report for the same period only shows $2,836.22 in total deposits (net + PST), resulting in a difference of $133.78. Here’s a breakdown of one example: May 28: Bank shows $2,500.00 received. PST Report shows a net of $2,252.25 + $135.14 PST = $2,387.39. Difference = $112.61. This pattern repeats for other entries too. The discrepancies are not consistent percentages or round amounts, so I’m unsure if: The accounting software is excluding parts of the deposits (e.g., tips, fees, non-taxable items). The PST code wasn’t applied correctly or partially applied. There are rounding or fee issues. I’m on a cash basis for PST reporting. All payments were e-Transfers from clients for taxable services. Question: How should I properly reconcile these figures? Should I only report the net taxable amounts listed in the PST report? How can I ensure my accounting software captures the full amounts accurately while applying PST correctly? Thanks in advance for your insights.

1 Comment 1
LollyNino_C
QuickBooks Team

Discrepancy between PST report (cash basis) and bank deposits—PST report shows $2,836.22, bank shows $2,970. Unsure why $133.78 is missing?

You can review your bank transactions and PST report to identify any missing or mismatched entries causing the discrepancy, info2197.

 

Based on the breakdown of the $2,500 you received, please review how the transaction was recorded in QuickBooks. If available, attach a screenshot of the transaction details for clarity.

 

Note that tips, fees, and non-taxable items may be excluded from the total sales if the tax setting is set to Exclusive of Tax. To ensure the invoice total matches your payment records, set the tax setting to Inclusive of Tax.

 

See the screenshot below for reference:

 

 

This adjustment aligns the deductions and ensures the recorded amount matches the $2,500 net pay on your QuickBooks and bank statement.

 

You can read these guides to learn more about how to reconcile your accounts in QuickBooks Online: Reconcile an account in QuickBooks Online.

 

If you need help with your bank transactions, leave a comment below.

Need to get in touch?

Contact us