Download or read book Bookkeeping using Excel or Google Sheets 2.nd edition written by Martin Mosfeldt, MBA and published by Martin Mosfeldt. This book was released on 2014-08-23 with total page 107 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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…).