cancel
Showing results for 
Search instead for 
Did you mean: 
Quanticangel
Level 1

Cleaning up credits on rec.

Hi everyone

 

To contextualize. We run online stores for several of our customers, we run everything and then when the store closes, we deduct our production and extra fees and give our customers their "profit" from the store, every time their clients order something, that order is added into an open SO which tracks all the production expenses, this SO is then invoiced and "closed out" with money from the bank account associated to Stripe. All of these stores constantly receive payments from Stripe, so controlling when are these payments being done and against which store is logistically hard from an accounting perspective

 

So basically there's a bunch of credits in the account that cannot be cleared and these have been accumulating like crazy. We use Stripe to receive payments from our customers but Stripe's payouts usually contain several payments not necessarily associated to a specific invoice. To close out the jobs, we "receive" the money from our stripe account into a bank account and then we immediately transfer this money into our operating account, as shown in attached picture, basically zeroing out these credit against a payment (transfer)

AR Cleanup.png

 

Problem is that this is being properly done now but there's a bunch of "received" payments that are not properly associated in the bank account and as shown below:

 

AR Cleanup 1.png

So, how can we clear these out? Theoretically speaking we already received this money in the form of (literally) dozens of payouts that were done and every time a reconciliation has to be done, all of the transfers done zero themselves out with the "payments" received but before me, this had been piling up and some team members couldn't grasp the idea so they missed doing the transfers immediately. I don't want to clear these payments out because then these invoices would reopen and the whole cycle would continue constantly

2 Comments 2
MariaSoledadG
QuickBooks Team

Cleaning up credits on rec.

Allow me to provide you some information on how you can clear those payments in your bank, Quanticangel.

 

With the integration of Stripe and QuickBooks Desktop, you'll definitely end up saving lots of time and effort. Generally, the steps you performed are the correct way of clearing payments that weren't associated with your bank. But, I still recommend reaching out to your accountant for the best way on how to do the recording. 

 

In addition, you'll also want to reach out to the Stripe Support Team so they can double-check and correct the mapping of your accounts. For your reference, you'll want to read these articles for more information:

Let us know if you have any other concerns about recording the payment. Remember, we're always right here to help you in any way.

Quanticangel
Level 1

Cleaning up credits on rec.

Hi

 

Question is still there tbh, the integration we're planning on doing but at the moment I'd like to get some insight as to how we could clean up these entries without affecting our P&L reporting

Need to get in touch?

Contact us