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

2

3

4

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

Installing the Excel Bookkeeping Template ......................................................... 11

2.1

Platform and Software Requirements............................................................................ 11

2.2

Installation ................................................................................................................................ 12

2.3

Backups ..................................................................................................................................... 12

Getting Started ........................................................................................................... 13

3.1

Settings...................................................................................................................................... 13

3.2

Navigation ................................................................................................................................ 13

3.3

Categories ................................................................................................................................ 13

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