Sales tax reserve ledger calculator

Calculate closing reserve cash by period and closing signed tax liability by period with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use closing reserve cash by period and closing signed tax liability by period to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Opening tax cash reserve ($)
100
Periods: name, output tax $, explicitly allowable input credits $, remittance $, reserve cash transferred in $
P1,100,20,50,80 P2,120,30,100,90
Opening net tax liability, signed ($)
0
Closing reserve cash by period ($)
P1: 130.00; P2: 120.00
Closing signed tax liability by period ($)
P1: 30.00; P2: 20.00
Final reserve minus net liability ($)
$100.00
Largest positive net-liability funding gap ($)
$0.00

Try another scenario

Opening tax cash reserve ($)
0
Periods: name, output tax $, explicitly allowable input credits $, remittance $, reserve cash transferred in $
P1,100,20,50,80 P2,120,30,100,90
Opening net tax liability, signed ($)
0
Closing reserve cash by period ($)
P1: 30.00; P2: 20.00
Closing signed tax liability by period ($)
P1: 30.00; P2: 20.00
Final reserve minus net liability ($)
$0.00
Largest positive net-liability funding gap ($)
$0.00
Calculation method

Calculation method

Closing reserve cash by period ($)

Prior reserve+entered cash transfer−remittance.

Closing signed tax liability by period ($)

Prior liability+output tax−entered input credits−remittance; a negative liability is a credit balance.

Final reserve minus net liability ($)

Final reserve−final signed liability.

Largest positive net-liability funding gap ($)

max(0,liability−reserve) across opening and closing period snapshots.

Symbols and units
a
Opening tax cash reserve ($)
b
Periods: name, output tax $, explicitly allowable input credits $, remittance $, reserve cash transferred in $
c
Opening net tax liability, signed ($)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A reserve-cash and supplied-tax-liability ledger. Input credits must already be determined externally. Negative cash or liability remains visible; this does not calculate tax eligibility or file a return.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

HMRC: tax fractions, invoice rounding and credit-note background; rules vary ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.