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 a loss, balance sheet, cash flow, explanatory notes a specifications, journal a ledger, rolling a 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, macrosab) and hard limit usage tiers (number of businesses, reports, accounts, records, currenciesab).For Google Sheets, my team uses PCs or MACs with Google Chrome as the default browser. ... Rather than test all that, we chose Chrome on a PC or MAC, which is free software that at the time of writing seems to work brilliantly. ... to end and develop your own system along with your reading, the formulas and principles introduced in each chapter should make themselves apparent at suitable times.
|Title||:||Bookkeeping using Excel or Google Sheets 2.nd edition|
|Author||:||Martin Mosfeldt, MBA|
|Publisher||:||Martin Mosfeldt - 2014-08-23|