Bookkeeping Using Excel or Google Sheets 2.ND Edition

This text in a hundred pages explains how to make a bookkeeping and financial reporting system in Google Sheets or Microsoft Excel. It is the simpler, faster, and better 2.nd edition of a tried-and-tested double-entry system, whose 1.st edition was already smart, dependable, and easy to use.

The text pragmatically and directly links accounting, ICT, and business management. It covers profit & loss, balance sheet, cash flow, explanatory notes & specifications, journal & ledger, rolling & fixed budget, group consolidation and KPI monitoring, system audit, error checking, data validation, and troubleshooting.

The system features automated sales tax/VAT with multiple rates and withheld tax, IFRS/GAAP compliant currency accounting with daily spot rate lookup, multiple reporting entities with multiple banks and types of bills, and unique hard-to-get facilities like dynamic single-entry sub-accounting, spreadsheet formula integration, and reporting in other languages.

The author is a senior businessperson with an MBA degree from Henley Business School, who owns and manages a portfolio of firms. The design is free from programming (VBA, scripts, macros...) and hard limit usage tiers (number of businesses, reports, accounts, records, currencies...).