Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Jul 24, 2022 6:22 AM UTC
Question

How to close out a square capital loan

I need some cleanup assistance for a working capital loan.  
 
Loan was setup last year, but was only setup with the initial deposit for the loan, 32807.47 and not the actual loan balance for 52095.00. Loan balance includes: previous loan of 13192.53, new loan of 32807.47 (46000.00) and 6095 fee (interest charge).
 
The loan was reclassified at YE with amounts and reasons I can't identify. The register only shows 27683.27 as of 1/1/22.
 
Do I adjust the original loan amount/register amount from YE, or do I just journal out the 6095 for interest and zero the account? If so, how? Because this is a Square working capital loan, the payments are taken before they get their daily payouts to their bank account. I have a full transaction history of their payments to pay down the loan (it's paid off), but these are not in Quickbooks.

19 replies

Level 5
Jul 25, 2022 3:13 AM UTC

What were all the Loan Payments classified as that they didn't lower the amount in the Loan Liability Acct when paid?  

 

And I'd want to find out about the mystery total change and what the loan was reclassified to?  I get that the odds of getting audited are pretty low, but if you ever are, not having this all cleaned up correctly might come back to bit you.

 

Jul 25, 2022 4:59 AM UTC

The loan payments were never entered because the client was previously tracking "income" based only on their bank payouts from square - those come out net of all fees, sales tax etc and net of any loan repayment.  So assuming the client reaches some minimum sales threshold on a given day, then Square takes an automatic payment.

 

Here's the movements:

Previous balance in Square loan acct 34,500.00

Deposit to Square loan account 32,807.47, balance now 67,307.47

Journal: DR Square loan 37,919.20 CR Sales 37,919.20 (to reclass Square loan interest); DR Contractors 2,973.48 CR Salary & Wage exp 2973.20; DR Square loan 1,750.00 CR 1,750.00 Salary & Wage exp (to reclass square payments)

Balance at 12/31/21 27,683.27

 

So I'm guessing they took some of this Square loan and journaled it to Sales income/Salary & Wage exp, because the Square loan payments "take up" some sales, and therefore the clients income was understated? 

 

Also I am now thinking I need to account for additional sales this year, as they paid this loan off?