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

1. Click on Payouts Received Summary -
2. Highlight and copy the payout line that you plan to match in QuickBooks

QuickBooks

1. + New - in the upper left corner of QuickBooks
2. Bank Deposit  - Select the bank account where the payout was deposited at the top and use the date that matches the payout date.
3. Paste the Skimmer payout data in the memo box at the bottom left of the Bank Deposit.
4. Add the payout processing fee in the bottom section as shown in the video.
5. Return to Skimmer in a different browser window.

Skimmer Billing Report - Payouts Received Detail

1. Payouts Received Detail
2. Select dates at the top and search for the matching Payout ID you copied in the summary.
3. These are the paid invoices to checkmark in your QuickBooks Bank Deposit. 
4. Return to the open QuickBooks Bank Deposit

QuickBooks Bank Deposit

1. Return to the unfinished Bank Deposit and checkmark the customers with the matching payout ID in Skimmer. 
2. The total should match the gross payment received - payout processing fee that you copy/pasted into the memo box. 
3. Save and close the Bank Deposit.

QuickBooks Bank Transactions

1. 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.