THE EXCEL ACCOUNTING - Bookkeeping Template

[Pages:27]THE

EXCEL ACCOUNTING

TEMPLATE

1.0

Do your own numbers in Excel - the simple way

Disclaimer

The information contained in this manual (the "Service") is for general information purposes only. Esset Financial Services assumes no responsibility for errors or omissions in the contents on the Service.

In no event shall Esset Financial Services be liable for any special, direct, indirect, consequential, or incidental damages or any damages whatsoever, whether in an action of contract, negligence or other tort, arising out of or in connection with the use of the Service or the contents of the Service. Esset Financial Services reserves the right to make additions, deletions, or modification to the contents on the Service at any time without prior notice. Esset Financial Services does not warrant that the Service is free of viruses or other harmful components.

Copyright ? 2018 by Esset Financial Services

All Rights Reserved. This book or any portion thereof may not be reproduced or used in any manner whatsoever without the express written permission of the publisher except for the use of brief quotations in a book review.

Excel Bookkeeping Template

Bookkeeping made simple

Stephan Zwanikken

Contents

Contents

1 General Information .................................................................................................... 7 1.1 System Overview...................................................................................................................... 7 1.2 Terms of Use.............................................................................................................................. 7 1.3 Contact ........................................................................................................................................ 7 1.4 Benefits........................................................................................................................................ 8 1.5 Features....................................................................................................................................... 9

2 Installing the Excel Bookkeeping Template .........................................................11 2.1 Platform and Software Requirements............................................................................11 2.2 Installation................................................................................................................................12 2.3 Backups .....................................................................................................................................12

3 Getting Started ........................................................................................................... 13 3.1 Settings......................................................................................................................................13 3.2 Navigation................................................................................................................................13 3.3 Categories ................................................................................................................................13

4 Creating Invoices ........................................................................................................ 14 4.1 Changing the Logo ...............................................................................................................14 4.2 Entering Invoice Data...........................................................................................................14 4.3 Checking and Saving as PDF .............................................................................................15 4.4 Processing the Invoice.........................................................................................................15 4.5 Clearing Invoice......................................................................................................................16

5 Inputting Sales & Income......................................................................................... 17

6 Inputting Purchases & Expenses ............................................................................ 19

7 Viewing Dashboard ................................................................................................... 21 7.1 Profit & Loss Statement ......................................................................................................21 7.2 Balance Sheet..........................................................................................................................22

8 Inputting Opening Balance......................................................................................23

9 Sales Tax Return .........................................................................................................25

10 Setting Up Next Year's Template ...........................................................................27

5

1 General Information

1 General Information

In this chapter we provide general information about the Excel Bookkeeping Template for small business owners, starting companies and freelancers.

1.1 System Overview

A free intelligent bookkeeping template for small business owners: An Excel based accounting system on a Windows or macOS Platform Tabular system for easy transaction recording Visual dashboards and reports for management guidance Easy invoicing

1.2 Terms of Use

Esset Financial Services provides you with access to a variety of resources on the website , including documentation and other product information, download areas, communication forums, import modules and other services and tools and samples. All documents and resources are subject to the following terms of use, unless we have provided those items to you under more specific terms, in which case, those more specific terms will apply to the relevant item. We reserve the right to update the terms of use at any time without notice to you. The most current version of the terms of use can be reviewed by clicking on the "Terms of Use" hypertext link located at the bottom of our Web pages.

1.3 Contact

Our primary point of contact is our helpdesk system.

7

Excel Bookkeeping Template

1.4 Benefits

Do you feel helpless when it comes to your accounting? Are you tired of receiving a huge bill from your accountant, year after year, for services that you could easily be doing yourself? Are you fed up with paying for a service that is purposefully shrouded in mystery and secrecy (because if you actually knew how simple it was, you'd never pay an accountant again)? Do you wish there was a simplified system that would allow you not only save time, but thousands of dollars in unnecessary fees, by doing your own numbers? Using the Excel accounting template saves you time you can spend with your family and saves you money you can invest in your business. Now doing your own accounting effortlessly is as simple as filling out a table. With the Excel accounting template, you can: Do your accounting with standard business software you already own. Don't worry, this is an exceedingly simple process, even the most unorganized, non-tech savvy person can understand. Have your entire accounting system set up and running on autopilot in under 15 minutes. Comply with both your needs and legal requirements Record your sales and expenses as easy as filling out a simple table. You don't have to learn new software. Avoid making fatal mistakes and additional tax assessments when recording your transactions. Unique integrity checks throughout the template make sure you do not forget anything. Create invoices simple and easy and send them to your customer as a PDF-document Save hundreds of dollars on accounting fees and software. No monthly fees. It is completely free!

8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download