THE EXCEL ACCOUNTING - Bookkeeping Template

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

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

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

Google Online Preview   Download