As a bookkeeper I am responsible  for recording and maintaining business transactions such as purchases, expenses sales revenue, invoices and payments. Using MS Excel, I've created my own system using existing formulas to finish financial statements. Like when I input data on sheet 1 cashbook, automatically it will reflect on the other sheet where the financial statements located.

These are the sample dashboard and financial reports I created for a local client in my previous job.

*DISCLAIMER: FOR CLIENTS PRIVACY AND CONFIDENTIALITY OF INFORMATION SOME DETAILS ARE FICTIONAL

Trial Balance

A/R

A/P

Double Entry Noncash 

Balance Sheet