The Pro add-on for any TEG shop: books, payroll, taxes
TEG Back Office
The office work of a small business, worked out from what your shop already records – and your books in free GnuCash, or kept up to date in QuickBooks Online or Xero.
What it does
TEG Back Office is the bookkeeping side of a TEG shop: payroll, supplier bills, expenses with their receipts, the sales tax return, 1099s, the month close and the money reports. It works beside every TEG shop – all 28 – and comes with the shop's Pro license – every shop has a Pro edition – not as a separate purchase, and it runs on your own site like the shop does.
- Your books in GnuCash, QuickBooks or Xero without typing anything twice: sales, payments, refunds, supplier bills and expenses, sent live to QuickBooks Online and Xero, or as a file for QuickBooks Desktop, GnuCash and ezAccounting. Each one goes once, and a payment reversed in the shop is reversed in the books too.
- Free GnuCash instead of a monthly subscription: download a GnuCash book already set up for your shop – the accounts, the sales tax table, your customers and vendors – with a plain-English guide beside it.
- The bank statement in about ten minutes a month: upload it (OFX, QFX, CSV, or a PDF that balances to the cent), and what the shop already recorded is matched for you. You answer one question for each other line – remembered next time – the statement is checked to balance, and you import one file into GnuCash.
- The sales tax return worked out from your invoices, monthly or quarterly, with the invoices behind every figure. Virginia shops also see the Form ST-9 lines.
- Payroll worked out from the time clock and commission the shop records (or the hours you type in), with pay advances taken off the next pay, approved once so it cannot change later, then exported for Gusto, ADP, Paychex, Patriot or QuickBooks – your payroll provider still withholds and files. Beside TEG-SALON each stylist's tips are filled in for you, on their own line.
- 1099s at year end: each contractor's and vendor's 1099-NEC amount, with a warning when a W-9, tax ID or address is missing. Tax ID numbers are stored encrypted and shown only as the last 4 digits.
- Bills and expenses: supplier bills paid in full or in part, what you owe and how overdue, rent and phone bills made for you each month, and receipts kept private.
- Close the month: a checklist that ticks itself from your records, then the month is locked, so nobody changes last month's figures by accident. An administrator can reopen it, with a reason that is kept.
- The money reports: profit and loss by month, budget against actual, a simple balance sheet, and cash flow for the next 30, 60 or 90 days with a plain warning when the bank may dip below the level you set.
- With TEG-METALSSHOP and TEG Jeweler, buy tickets reach the books as purchases, once each.
- On the phone, in TEG Companion: this month's spending, the bills coming due, and an expense added with a photo of the receipt (its location removed) or the miles you drove.
- With TEG Rover switched on in the shop, an errand someone paid for goes into the expenses by itself, once. With TEG-REPAIRSHOP and TEG Rover, technicians also add an expense with a photo of the receipt from the phone, even with no signal, and log a day's house-call mileage in one tap.
It prepares the figures; it is not an accountant. Your accounting program stays the books, and your accountant and payroll provider still do the filing.
Which shops it works with
It works beside every TEG shop – all 24, and their editions – and reads what that shop already keeps: its staff, its invoices and payments, and its hours and pay where it has them. Where a shop keeps no clock, the hours are typed in on the payroll run.
Every shop hands it one staff list by the same rule: the shop's own staff first (an electrician's engineers with a login, the counter clerks, the tasting room staff, the vets and then the nurses, the warehouse roles, the stylists and the front desk), then the others allowed into the back office, then the administrators – each person once. TEG-SALON leaves chair renters out (they are self-employed), and TEG-BANDB keeps the house owner off payroll (paid from the profit) unless they also hold a staff role.
Hours come from TEG-REPAIRSHOP's time clock, TEG-AUTOSHOP's technicians, TEG-LAWNCARE's crew time, TEG-HOMECARE's visit time, the new time clock in TEG-PESTCONTROL 1.8.0 (finished hours per technician per day) and TEG-CLEANING's hourly cleaners' visit minutes. Pay comes from TEG-SALON's Commission (tips beside it, never in it), TEG-METALSSHOP's clerk commission, TEG-AUTOSHOP's flat-rate pay (in the Commission column), TEG-LASTDJ's DJ pay for each linked performer and TEG-CLEANING's per-visit and percent pay (tips stay on its cleaner pay report).
Included with Pro: TEG-REPAIRSHOP, TEG-METALSSHOP, TEG-MARKET, TEG-WINERY, TEG-VETCLINIC, TEG-ELECTRIC, TEG-RESTAURANT, TEG-SALON, TEG-AUTOSHOP, TEG-LAWNCARE, TEG-HOMECARE, TEG-BANDB, TEG-THERAPIST, TEG-LEGAL, TEG-WHOLESALE, TEG-MARKETER, TEG-EVENTCENTER, TEG LastDJ, TEG-HVAC, TEG-CLEANING, TEG-PESTCONTROL, TEG-FARM, TEG Creator and TEG-BUTCHER.
Where billing goes through claims or session charges (TEG-HOMECARE, TEG-THERAPIST), there are no sales to send or sales tax to work out – bills, expenses, payroll, the bank statement, 1099s and the month close still work. TEG-MARKETER is usually beside another shop, and then that shop's staff and sales are the ones read; on its own, its agency invoices are its sales (TEG-MARKETER 1.9.0 and later).
One gap, said plainly: TEG-FARM's sales reach the books but its payments do not yet. TEG-EVENTCENTER and TEG-LASTDJ now keep a sales tax rate (Event settings > Sales tax %, 0 until you set it), and the sales tax page reads it.
Questions
What does it cost?
Nothing extra. It comes with the shop's Pro license, and the free 30-day Pro trial includes it.
Does it work with my shop?
Yes. Since 2.6 it works beside every TEG shop, all 28 of them, and their editions (Jeweler, Tire Shop, Bakery, Deli, Food Truck). It reads that shop's staff, invoices and payments; what a shop does not keep, such as a time clock, is typed in.
Does it do my taxes?
It prepares them: the sales tax return worked out from your invoices, 1099 amounts with the W-9 details, and payroll ready for your provider. Filing is still yours, your accountant's and your payroll provider's.
Why GnuCash?
Because it is free, it runs on your own computer, and it is a real double-entry book your accountant can read. The Back Office sets the book up for your shop and hands it one file a month, so the books take about ten minutes instead of a monthly subscription. If you already pay for QuickBooks Online or Xero, it keeps those up to date instead.
Can I try it here?
Yes: the try-it page signs you in to the demo back office, where it sits beside TEG-REPAIRSHOP and its sample data. Nothing you do there is paid, sent or filed.
What's new
- With TEG Rover: errands paid for go into the expenses by themselves, and receipts and house-call mileage come from the technician's phone.
- 2.7: beside TEG-SALON, each stylist's tips for the pay period are filled in on the payroll run for you, on their own line and never added into commission – change any of them before you approve. When the only people listed for payroll are site administrators, the payroll screen says so: give staff a WordPress login to pay them here. And every shop now hands over its staff by one rule: its own staff, then the others allowed into the back office, then the administrators, each once.
- 2.6: works beside every TEG shop, 28 in all – new: TEG-HVAC, TEG-CLEANING, TEG-PESTCONTROL, TEG-FARM, TEG-EVENTCENTER, TEG-LASTDJ, TEG Creator, TEG-BUTCHER and TEG-MARKETER. Fixed: TEG-SALON tips paid on top for the stylist are no longer added to the sale in the accounting files.
- 2.5: pay advances – record one, and the next payroll takes it off the pay; each run shows the advance repaid and the net to pay.
- 2.4: works with the shops' report cards, on the phone and on the desktop, and the bills you keep here fill in the cash flow card.
- 2.3: the Back Office on the phone in TEG Companion – spending, bills coming due, a receipt photo or the miles – and errands someone paid for into the expenses by themselves.
- 2.2: the sales tax return (with Virginia's Form ST-9 lines), 1099s, closing the month with a lock, recurring bills, cash flow, budget against actual, a balance sheet, PDF bank statements, and a payment reversed in the shop reversed in QuickBooks Online and Xero too.
- 2.1: Set up GnuCash – a GnuCash book made for your shop – and the monthly bank statement matched for you.
- 2.0: payroll became the Back Office – supplier bills, the expense log with private receipts, a profit and loss, and QuickBooks, Xero, GnuCash and ezAccounting exports and sync.
