Home › Finance manager toolkit › Small Business General Ledger & VAT (Excel)

Small Business General Ledger & VAT (Excel)

Chart of accounts, journal, trial balance, P&L, balance sheet and a VAT return — in one workbook that balances itself.

Small Business General Ledger & VAT (Excel)

A complete double-entry bookkeeping workbook for a small company or freelancer who is not ready for accounting software.

  • Accounts — a 24-account chart you can rename or extend; account type drives every report
  • Journal — 1,000 lines, account names looked up, VAT code per line, out-of-balance check per reference
  • Trial Balance — movements for the period you set, debits = credits proven
  • P&L — income, cost of goods, gross margin, operating expenses, net profit
  • Balance Sheet — assets vs liabilities + equity + profit, with a zero check
  • VAT Return — standard-rated, zero-rated and exempt sales; recoverable input VAT; net payable. Default rate 5% (UAE/KSA-style), change it once.

Sample entries included. Formulas only, no macros. Excel 2016+, Google Sheets.