Purpose
These reports help you audit consignor payouts for accuracy, prevent fraud, and troubleshoot the integration with QuickBooks Online (QBO) if needed. They are essential for financial compliance, bank reconciliation, and system sync validation.
To learn more about creating customer reports, please view our Custom Reports Overview guide.
QBO Synced Report
Description:
This report helps you identify which consignor payout checks did or did not sync successfully with QuickBooks Online. It’s crucial for reconciling financial records between SimpleConsign and your accounting software, and for resolving sync issues.
Base:
Custom Payout Activity
Fields to Include:
| Field Name | Description |
| First Name | Consignor’s first name |
| Last Name | Consignor’s last name |
| Check # | Payout check number |
| Date Created | When the check was issued |
| QB Synced | Indicates if the payout synced to QBO |
Filters:
| Filter | Use Case |
| QB Synced is “False” | View checks that did not sync with QuickBooks |
| Date Created is after [date] | Focus on recent payout activity |
Consignor Positive Pay
Description:
Positive Pay is a security measure that helps you detect and prevent check fraud by comparing details of issued checks against your bank’s records. This report is used to create a list of issued checks that can be uploaded to your bank for verification.
Base:
Payout Activity
Fields to Include:
| Field Name | Description |
| Date Created | When the payout was recorded |
| Check # | Check number associated with payout |
| First Name | Consignor’s first name |
| Last Name | Consignor’s last name |
| Payout By | Method used for payout (Check, ACH) |
| Amount | Payout amount |
Filters:
| Filter | Use Case |
| Date Created is [date] | View payouts from a specific date |
Tips
-
Use the QBO Synced filter regularly to monitor integration issues early.
-
Match Positive Pay exports with your bank’s format to streamline check validation.
-
Always include check numbers and payout details when auditing or exporting.