Skip to content

Sales tax and VAT

BaseCloud keeps track of the tax on every invoice, credit note and bank entry, so that at the end of each period you can see what you owe and file your return. In the United States that's sales tax, often a state rate plus county and city rates. In South Africa it's VAT, at 15%.

What BaseCloud does and doesn't do:

  • It charges the rate you set on each line, records the tax in your books and reports it by rate and by each part of a rate, ready for your return.
  • It doesn't look up rates by address and doesn't file your return or pay the tax for you. You (or your accountant) set your rates, file with your state or SARS, and record the payment.

The full report needs your books to be on. Without them, the Sales tax card on the Reports page adds up the tax on your invoices instead.

Your tax rates

Your rates are in Accounting › Chart of accounts › Tax rates. Each rate is for sales or purchases (or is exempt, zero-rated or no tax), and its tax posts to an account, normally Sales Tax (US) or VAT (South Africa).

  • US: combined rates. A rate can be made of parts: a Texas rate of 8.25% might be the state's 6.25% plus a city's 2%. Each part posts to its own account if you like, and the report shows each part, so you can see what you owe each authority.
  • South Africa. You start with Standard Rate VAT 15%, Zero Rated and Exempt.
  • Moving from QuickBooks? QuickBooks keeps US sales tax rates by agency, outside its chart, so none come across when your chart is imported. Add a rate for each agency after your books start.

When a rate changes, add the new one and use Replace and archive on the old one: your items, recurring lines, rules and clients move to the new rate, and invoices already made keep the tax they charged. See Chart of accounts.

Charging tax on invoices

Each line on a quote or invoice has a tax rate. How the prices are written is set in Settings › General:

  • Invoice prices are: Tax exclusive (tax is added on top, usual in the US), Tax inclusive (prices include tax, usual for South African retail) or No tax. Each document can still be set on its own.
  • Round tax: On each line (each line's tax is rounded, then added up) or On the invoice total (the tax is worked out on the total and rounded once, as QuickBooks and most till systems do; a cent of difference goes on the largest line). It applies to quotes and invoices saved from then on.

Two rates with the same percentage? With your books on, when two of your sales rates share a percentage (two cities at 8.25%), the invoice editor asks you to Pick a rate on the line, so each city's tax lands in the right place. The editor offers only sales rates.

What the document prints: the tax is called Sales tax or Tax on US documents and VAT on South African ones, and a layout can show a Tax by rate table with each rate by name. A South African business with a VAT number in its settings gets invoices headed Tax Invoice with its VAT number, as SARS requires. See Set up invoicing.

A client's own tax

Some clients are taxed differently: a reseller with an exemption certificate, a nonprofit, or a client in another city. Open the client, go to their Accounting tab and find How is this client taxed? (it needs Edit Invoices). Click Change and pick:

  • Each item's own tax rate (the default): each line keeps its own rate.
  • One tax rate for this client (books on): every taxable item on this client's quotes and invoices is charged the rate you pick. Items with no tax stay that way.
  • Exempt from tax: taxable items are charged 0%. Record the Exemption certificate number, the date the Certificate good until, and the Certificate file from the client's files. After the certificate's date, new documents are taxed as normal again, so keep it up to date.

It applies to quotes and invoices made from then on, by you, by automations, by the AI connection and by recurring invoices. A line where someone picked a rate by hand keeps it. Documents already made don't change, and old documents brought over from another system keep the tax they had.

Tax on purchases

When you record money spent in Spend, receive or transfer money or while reconciling, a line can carry a tax rate:

  • South Africa: pick your VAT rate for purchases on spending you can claim VAT back on. It shows on the report as Tax on purchases (input VAT) and comes off what you owe.
  • United States: sales tax you pay on a purchase is part of what it cost. Enter the whole amount with no tax. BaseCloud refuses a purchase line with sales tax on a US chart and says so.

A sales rate can't be used on money spent, and a purchase rate can't be used on money received.

The Sales tax report

On the Reports page, the Sales tax card (in the Sales & Accounting group, and on your Books dashboard) shows, with your books on and for someone with View Books, for the dates you pick:

Part What it shows
By tax rate For each rate: your Sales at that rate, the Tax on sales, Purchases, Tax on purchases, and the Tax owed (tax on sales less tax on purchases).
No tax rate Tax charged on lines with no tax rate linked. It's in your tax account and in the total, so it's never lost. Click it to see the lines and link them to the right rate.
Written off (bad debts) Invoices you wrote off, by rate, with their tax taken off what you owe (bad debt relief).
By component Each part of a combined rate (state, county, city), with the sales it was charged on and its tax as posted.
Sales summary Gross sales, Taxable sales, Zero-rated sales, Exempt sales, and Sales with no tax rate and no tax: the figures a US return or a VAT201 starts from.

Click any rate to list the lines behind it: each invoice, credit note or bank entry, with its date and amount. Open one to see where it came from. Notes under the report tell you when your tax accounts moved by a different amount than the tax shown (an entry made straight to the tax account, or tax you paid over), so you can check before you file.

Credit notes take their tax off in the period they're dated. Voided invoices are left out.

Invoice basis or payments basis

The card's Basis decides when tax counts:

  • Accrual (invoice basis): tax counts on the invoice's date, paid or not. Most US states and most South African VAT vendors file this way.
  • Cash (payments basis): tax counts as the invoice is paid, in proportion, part payments included. Some small South African VAT vendors are registered on the payments basis, and some US states allow cash reporting. Invoices that were still open when your books started count when they're paid, too. See Cash or accrual.

Use the basis you're registered on, and set it as your books' Reporting basis in Settings › Books so every card opens on it.

File your return and pay the tax

  1. Make sure the period is complete: every invoice raised, every credit note made, every bank line reconciled. See Month end.
  2. Open the Sales tax card for the return's dates on the right basis. Check No tax rate is empty, and read the notes under the report.
  3. Print or save as PDF, or Download as CSV, from the card's menu and keep it with your return.
  4. File with your state, county or city (US) or on SARS eFiling (South Africa) from those figures.
  5. When you pay, record the payment from your bank to your Sales Tax or VAT account: as spend money, or by coding the bank line to that account when you reconcile. A VAT refund from SARS is received money coded to the VAT account.
  6. Set a lock date at the end of the period, so nothing in a filed return can change.

Money in another currency

Your books are kept in one currency. A payment received in another currency is kept as the client's credit but isn't put in your books, and BaseCloud leaves a note on the client. Post a manual journal by hand at the rate you were paid.