Mastering Spreadsheet Bookkeeping will equip you with the knowledge to write your accounts spreadsheets successfully. Whether you are studying for a qualification in bookkeeping or you are a small business owner needing to bring your accounts up-to-date, Mastering Spreadsheet Bookkeeping will give you the knowledge and skills do this effectively, helping you to set up your own computerized accounting package without splashing out on expensive new software. With Mastering Spreadsheet Bookkeeping you will gain a thorough knowledge of how to use spreadsheets to their fullest advantage, saving you invaluable time and labour. Aimed at students of bookkeeping and small business owners, Mastering Spreadsheet Bookkeeping takes you step-by-step through what you need to know to use spreadsheets with confidence. With its focus on MS Excel and its clear, step-by-step approach, Mastering Spreadsheet Bookkeeping will help you to develop your own computerized bookkeeping skills with confidence. In addition, exam-style questions and answers are provided for self-testing so you may consolidate your bookkeeping knowledge as you learn.

The book explains the principles and practice of bookkeeping sequentially, including: ·The bank reconciliation ·Writing up the petty cash book ·Extracting a trial balance ·Accruals and prepayments ·Setting up a limited company ·Accounting for VAT Plus step-by-step guides to compiling a balance sheet, depreciation, accounting for bad and doubtful debts and much more. The 10th edition also includes significant enhancements to reflect the teachings of the principle bookkeeping institutes as they endeavour to raise the professional competence of their members. For example, accounting staff are increasingly being required to extend their record keeping into management accounts areas. The new edition includes chapters on stock control and budgetary control accounting. In addition, it will include more detailed guidance on the significance and importance of ratio analysis and statements of sources and application of funds, plus the latest available IAB and ICB exam papers.

This book describes a practical and easy to implement bookkeeping system, that anyone will be able to use without previous knowledge of finance, accounting or book-keeping. It provides a proven methodology that will enable you to: · Create a simple book-keeping system that anyone can manage · Create an easy to use system that controls the paperwork · Calculate VAT liability or VAT refund figures · Produce key financial figures concerning your business · Exercise proper financial control over your business · Reduce year-end accounting fees · Reduce the stress from dealing with book-keeping and paperwork If you can create a shopping list, then you can create a list of financial transactions and do your own book-keeping. It really is that simple!

This second edition of the bestselling Mastering QuickBooks 2020 is updated and improved to focus on advanced QBO features, techniques for managing sales taxes, and budgeting and reporting best practices Key Features Understand how to manage sales taxes and transactions Explore advanced bookkeeping techniques such as using the custom chart builder, importing budgets, and performing smart reporting with Fathom Become proficient in using QuickBooks Online and implement best practices to avoid costly errors Book DescriptionIntuit QuickBooks is an accounting software package that helps small business owners to manage all their bookkeeping tasks independently. This latest edition of Mastering QuickBooks takes you through the range of new features and updates available in QuickBooks Online (QBO). Creating multilingual invoices, tracking mileage, working with a cash flow dashboard that helps you with cash forecasting and planning reports, and uploading a batch of bills and checks are just a few of the new features covered in this edition. As you progress, you’ll learn how to manage sales tax, including how to set up, collect, track, pay, and report sales tax payments. Dedicated sections will also take you through new content focused on the latest features in the QBO line-up, while also showing you the different types of businesses that can benefit from QBO Advanced. In addition to this, you’ll explore how to export reports to Google Sheets, use the custom chart builder, import budgets, perform smart reporting with Fathom, and much more. By the end of this QuickBooks book, you'll be well-versed with the features of QuickBooks and have the confidence to manage all your bookkeeping tasks with ease.What you will learn Discover the new features of QBO and find out what the QBO line-up offers Get to grips with bookkeeping concepts and the typical bookkeeping and financial accounting cycle Set up QuickBooks for both product-based and service-based businesses Track everything from billable and non-billable time and expenses to profit Generate key financial reports for accounts, customers, jobs, and invoice items Understand the complete QuickBooks payroll process and track payments made to 1099 contractors Manage various bank and credit accounts linked to your business Who this book is for The book is for small business owners and bookkeepers or accounting students who want to learn QuickBooks Online and understand how to implement and use it effectively. Whether you’re a bookkeeping beginner or have some experience already, this book will help you learn to use Intuit QuickBooks Online confidently.

During live CPE training sessions, and through Excel articles featured in magazines such as the Journal of Accountancy and California CPA Magazine, Jeff Lenning, founder of Excel University, Inc., has shown thousands of CPAs and accounting professionals across the country how to use Excel more effectively. Drawing on his experience as an auditor, a financial analyst in industry, an accounting manager at a public company, and a consultant, he has demonstrated how to leverage Excel in order to improve efficiency by reducing the time it takes to complete job tasks. Written to reach those he won't have the opportunity to meet in one of his CPE sessions, Lenning's series, Excel University: Microsoft Excel Training for CPAs and Accounting Professionals, offers a comprehensive collection of the features, functions, and techniques that are of direct benefit to accountants working in industry, public practice, consulting, or not-for-profit. Concentrating on Excel for Windows, his books offer a hands-on approach to learning and include narrative, screenshots, video content, Excel practice files, and exercises that demonstrate the practical application of the items presented in each chapter. Visit http: //www.excel-university.com to access the Excel University video library and to download the practice files. Features, functions and techniques are presented in a sequential and progressive manner, so the books are best read in order. In Volume 1, the author presents material and information that will prove useful to every accountant, regardless of the type of work they do. Blown away by the power of Excel, readers are sure to find this series relevant, enlightening, and extremely easy-to-follow.

Get up to speed with QuickBooks Online 2020 for financial management and bookkeeping Key Features Create a dashboard that highlights your company’s financial activity and status upon login Manage customers, vendors, and products and services seamlessly with QuickBooks Explore special transactions such as recurring transactions, managing fixed assets, setting up loans, and recording bad debts Book DescriptionIntuit QuickBooks is an accounting software package that helps small business owners to manage all their bookkeeping tasks. Its complete range of accounting capabilities, such as tracking income and expenses, managing payroll, simplifying taxes, and accepting online payments, makes QuickBooks software a must-have for business owners and aspiring bookkeepers. This book is a handy guide to using QuickBooks Online to manage accounting tasks and drawing business insights by generating reports easily. Using a fictitious company, the book demonstrates how to create a QuickBooks Online account; customize key settings for a business; manage customers, vendors, and products and services; generate reports; and close the books at the end of the period. QuickBooks records your debits and credits, so you don't need to learn accounting. However, you will find out what happens under the hood and understand how your financial statements are impacted by what you do in QuickBooks. You'll also discover tips, shortcuts, and best practices that will help you save time and become a QuickBooks pro. By the end of this book, you'll have become well-versed with the features of QuickBooks and be able to set up your business and manage all bookkeeping tasks with ease.What you will learn Get to grips with bookkeeping concepts and the typical bookkeeping and accounting cycle Set up QuickBooks for both product-based and service-based businesses Track everything, from billable and non-billable time and expenses to profit Generate key financial reports for accounts, customers, jobs, and invoice items Understand the complete payroll process and track payments made to 1099 contractors Manage various bank and credit accounts linked to your business Who this book is for If you’re a small business owner, bookkeeper, or accounting student who wants to learn how to make the most of QuickBooks Online, this book is for you. Business analysts, data analysts, managers, and professionals working in bookkeeping, and QuickBooks accountants will also find this guide useful. No experience with QuickBooks Online is required to get started; however, some bookkeeping knowledge will be helpful.

Double-entry accounting can be easy if it's explained well, and Mastering Book-keeping does just that. Now in its updated 8th edition, this popular book has helped thousands of people to get to grips with book-keeping. It explains the principles and practice of book-keeping sequentially, and includes: - The daybooks and ledger accounts - End of year accounting - Sole proprietorships, limited companies, partnerships and not-for-profit organisations - Using computers for accounting - Accounting for VAT - Progressing to more advanced management accounting - The implications of the Data Protection Act 1998 on book-keepers Plus step-by-step guides to compiling a balance sheet, depreciation, accounting for bad and doubtful debts, and much more. Everything is made clear with easy-to-follow explanations. Typical transactions are illustrated throughout to make the information even easier to understand. This book is suitable for those preparing for the examinations of ICB, AAT, IAB, OCR, AQA and all other courses in book-keeping and accounts.

The growth of small businesses in the 1990s is good news for the self-employed bookkeepers. A growing number of business owners are cutting their budgets by contracting out bookkeeping tasks rather than hiring full-time employees to keep their financial records straight. The need for dependable, home-based bookkeepers has never been greater, and neither has the money-making potential of the emerging work-at-home phenomenon.

Get up and running with Xero in a flash Xero is fast emerging as the leader of online accounting software around the world, representing a serious challenge to MYOB, Sage and Quickbooks. Xero For Dummies provides you with all the information you need to set up your own Xero account from scratch, convert to Xero from another accounting software provider or start using Xero to its full potential. Easy to use and deceptively powerful, Xero is so much more than a spreadsheet – it can help you streamline reporting; manage inventory; simplify accounts; and organise suppliers, customers and more. Automatic imports, intuitive coding and seamless synching across multiple business platforms gets the paperwork done quickly so you can get back to running your business. This new fourth edition includes updates to the interface and coverage of the newest features, including updates on generating reports, working with fixed assets and managing contacts, sales and payables so you can optimise your system to help your business thrive. Fine-tune your set-up, or convert from another accounting program Manage daily activities with contacts, accounts, sales and payables Master weekly and monthly reporting routines Track inventory, monitor your business and get the most out of Xero You didn't start your business in order to become an accountant, but bookkeeping is critically important to the short- and long-term health of your company. Xero simplifies the process and saves you time, and Xero For Dummies helps you leverage every feature Xero has to offer.

Created especially for the Australian customer! Take the stress out of bookkeeping with easy-to-follow advice from the experts Do you have trouble balancing the books for your small business every month? Or are you a professional bookkeeper wishing to hone your skills? Whatever your bookkeeping needs, this practical guide to the ins and outs of business transactions will help you ensure that the numbers add up every time. Follow the bookkeeping cycle -- make the end of the month hassle-free by recording transactions properly Translate the financial lingo -- know your assets from your equity and don't get depressed about depreciation Prepare financial reports -- understand how a business is doing by analysing Profit Use accounting software -- throw out the shoebox of receipts and discover a new world of technology Stay on the right side of the law -- tick all the boxes, from registering a business to paying employees correctly Get qualified -- succeed in Certificate IV Bookkeeping with lots of tips and info for your core units Crack the GST code -- keep the tax wolves from the door by calculating GST correctly Tame the bookkeeping tiger -- understand accruals, general journals, inventory management and more