How To Use Excel As An Accounting Program

A Simple Accounting Program In Excel For Businesses And Accounting Consultants With Low Budget For An Accounting Software

There is One Thing I learnt Over 20 Years Experience In Accounting And Finance

Many organizations don’t have good accounting systems. “I have encountered so many of them, working as an employee and as consultants as well as carrying TAX audit exercises for the Federal Inland Revenue Service (FIRS)

Here are some of the costs of not having a proper system of book-keeping and accounting:

• It’s a daunting task to produce reports or get management information from source documents.

• It cost money in the long run. A business I worked for where I set up a computerized accounting system almost lost 15 million naira through omission of a customer’s debt.

• Miscalculated expenses and costs will make you lose track of your finances.

• It will have a disastrous effect on tax estimate as you will likely be taxed to the extreme.

• Potential lost of funds through the banking system. If you don’t have a good Book-Keeping & Accounting system, bank reconciliation will not be feasible. A company I worked issues a chq of 10 million naira for transfers to 2 parties – a 2 million naira and another 8 million but the vendor with 2 million was wrongly credited with 3 million. 2 months after I joined, I spotted the error through reconciliation because of the system I set up.

• Misleading financial reports may not give you a true picture of you cash flow.

• A poor bookkeeping does not look good in a loan application process and will not endear investors to commit funds in the business for expansion

Do you use an accounting software For Your Business? If Yes, This Page is Not For You.

On this page, I am going to show you how I helped companies develop customized accounting packages as well as other industry-Specific Templates, using Microsoft Excel

The Following Lists are people/Organizations this program will benefit:

• Do you want to be a Virtual Accountant and you need A system to keep track of your client’s financial transactions without investing so much on accounting software? This program is for you

• Are you a small or medium sized business but do not have a budget for an accounting software? This program is for you

• Do you use Excel to keep track of your business finances but confronted with challenges on how to organize Excel to produce Financial Reports? This Program is for you.

•  If you operate a bank account not more than 10 and have product varities of not more than 50.

Easily customizable chart of accounts to suit your business needs.

Automated Generation of Trial Balance and Financial Statements

Video Tutorials on How to use & customize the program

No Monthly Subscriptions

Brief tutorial on how to access your file remotely from any location 

CLICK THIS LINK TO ACCESS FREE DOWNLOAD ALL THE VIDEO GUIDE TO THIS FILE

About The Author -Emmanuel Daniels

• A Chartered Accountant with over 20 Years Experience In Accounting & Finance

•  Work & Consulting Experience Across Different sectors in commercial Banking, Investment Banking, Shipping & Logistics, Agriculture, Pharmaceutical, Real Estates, FinTech Organizations.

• Involved in human capacity development in areas of Advanced Excel, Data analysis, Financial Modeling, Business Plan Writing, Project Investment Appraisal.
• Outsourced training consultant for NEXIM, BOI

• Developed information and financial reporting templates across industries.

• Implemented Cloud-based Accounting software (QuickBooks online, HIKE Point Of Sale) and Desktop Accounting Software (Tally ERP, QuickBooks Premier and Enterprise, Sage 50).
• Wrote business plans and financial model design for organization

What Are The Contents Of This Excel Accounting Package?

• Sales Journal Record – For Tracking Revenue & Facilitating Posting Of Customers Ledger

• Purchase Journal Record – For Tracking Purchases & Facilitating Inventory Posting & Supplier’s Ledger

• Customers’s Ledger – A simplified Workbook for tracking Customer’s Transactions and Balances

• Supplier’s Ledger – For Tracking Supplier’s Balances

•  Inventory Journal – Tracking up to 50 inventory items with automated weighted average Costing that also calculated cost of sales and provides Inventory valuation

• Consolidated Report – This is a single workbook that can help you manage up to 20 bank account in local and foreign currencies (GBP & USD), General Journal entries, Working Trial Balance, Extended Trial Balance, Final Trial Balance, Statememt Of Profit Or Loss & Statement of Financial Position. Just post to the GL account and everything syncs to the financial statements.

If you are a consultant, I will also show you how to manage the accounts of your clients remotely using these Excel Accounting Templates. Details will be provided on the video tutorials you can access for FREE

The Offer Price Is For a LIMITED Period Of Time

Contact Number: 08035786640

email: [email protected]