Accounting

From JMLWiki
Revision as of 14:36, 15 January 2022 by Benoit (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Accounting keeps track of the money coming in & out of the business and makes sure the invoices are paid and things are recorded in QuickBooks Online. QBO is how we keep track of the moneys and what the accountant uses at the end of the year to do the taxes.

How we get money

JML's operations typically gets money from two sources:

  • Stripe, which is what all the online rental invoices go through
  • Square, which are all the expendables sales that are swiped through the square terminal.

Note that Square should NOT be used for payment of rental invoices. We should always use stripes. Stripe allows us to charge the client card if there is L&D. Square does not.

After a couple of days, Stripe & Square transfer the money (minus their cut) into our INCOME bank account.

In QuickBooks, we have 2 holding account (Square and Stripe) which represent the payments that have not been transferred to our bank account yet. These are clearing accounts.

Daily Sales Reconciliation

When a CurrentRMS invoice is posted, it gets recorded in QuickBooks as an Invoice that still needs to be paid. Because we don't post the invoice until we are paid, we just need to let QBO know that the money has been received to keep the books accurate. We use an online program called PayTracker [1] which allows us to record the transactions in quickbooks.

Paytracker does the following:

  • Match the Invoice (generated by CurrentRMS) and the Payment we received and marks the invoice as paid in QBO
  • Records the deposit to the Clearing account (Square or Stripe)
  • Records the transfer from Square/Stripe to our bank account (as a transfer from the Clearing account to the INCOME account)
  • Records the transaction fee in the clearing accounts.

At the end of the day, we need to load into Paytracker and perform the following:

  • Download Historical Transactions
  • Match the individual Payments
    • For a transaction, select "Review & Sync" Button
    • Clear the Customer Entry (it might not match the customer in QBO)
    • Type the actual customer name
    • Select "Save & Sync"

Any other transactions, you can select them all and select the "Synch with QuickBooks"

All transactions for the day should be reconciled.

NOTES: If the QBO invoice date is AFTER the payment (i.e. you don't post the day the invoice happens), the PayTracker will create ANOTHER transaction (Sales Receipt) and QuickBooks will be messed up. Same thing happens if you don't clear the customer field and put the quickbooks customer instead.