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.