How I reconcile, or match, Skimmer Online payments to QuickBooks
This is my step-by-step process on how to manage payouts when the processing fee is deducted.
Here’s how I match payouts, handle processing fees, and reconcile payments in both Skimmer and QuickBooks. If you've been struggling with this process, I hope this helps you out.
Skimmer Billing Report - Payouts Received Summary
- Click on Payouts Received Summary -
- Highlight and copy the payout line that you plan to match in QuickBooks
QuickBooks
- + New - in the upper left corner of QuickBooks
- Bank Deposit - Select the bank account where the payout was deposited at the top and use the date that matches the payout date.
- Paste the Skimmer payout data in the memo box at the bottom left of the Bank Deposit.
- Add the payout processing fee in the bottom section as shown in the video.
- Return to Skimmer in a different browser window.
Skimmer Billing Report - Payouts Received Detail
- Payouts Received Detail
- Select dates at the top and search for the matching Payout ID you copied in the summary.
- These are the paid invoices to checkmark in your QuickBooks Bank Deposit.
- Return to the open QuickBooks Bank Deposit
QuickBooks Bank Deposit
- Return to the unfinished Bank Deposit and checkmark the customers with the matching payout ID in Skimmer.
- The total should match the gross payment received - payout processing fee that you copy/pasted into the memo box.
- Save and close the Bank Deposit.
QuickBooks Bank Transactions
- Go to the Bank Transaction feed and search for the deposit with the matching amount and click “match.”
It may seem like a lot of steps, but it actually goes very quickly and makes reconciliation at the end of the month a breeze.
If you have question, please comment below or message me.