Hello there, @Judster2. I understand how challenging it can be when QuickBooks won't recognize data you’ve already entered. This error typically arises from an account mapping mismatch rather than a data entry error.
Please know that QuickBooks is sensitive to formatting in the Tax Identifier fields. Even if the SIN is present, the system will reject it if there are invalid characters or a vendor type mismatch. You'll want to ensure the numbers are entered as continuous and don't contain extra spaces, hyphens, or dashes in the SIN/Business Number field.
Moreover, T4A boxes are mapped to specific expense accounts. If your commissions aren't showing up, it's likely because the expense account you use to pay the agents isn't mapped to Box 20 in the T4A setup. To verify, here's how:
- Go to the Reports menu.
- Select Suppliers & Payables, and then T4A Detail.
- Review which accounts are pulling data. If your commission account isn't there, you need to map it.
Since you're only seeing deductions, it's because those deduction items are currently mapped to a T4A box while the gross commission is not.
For more details, please check this page: Using T4A forms in QuickBooks Desktop.
Please don't hesitate to click the Reply button if you have other questions about QuickBooks.