Automated Excel Template to record Cash & Bank Transactions (VBA)

 


#Excel​ #ExcelTemplate​ #ExcelCustomization​ #Receipts​ & #Payments
How to use our RECEIPTS & PAYMENTS EXCEL TEMPLATE PART


This Excel Template will be useful to anyone who is in charge of recording and tracking INFLOWS (Receipts) into the Cash or Bank Accounts and OUTFLOWS (Payments) going out from the Cash or Bank Accounts. 


Using this Excel Template will enable any user to perform the following task:
1. Set up a Chart of Account (or upload existing Chart of Account)
2. Set up Project Centres (Project Codes) or Branches/Divisions/Department
3. Set Payment Partners (Customers, Vendors, Employees, Investors, etc). These are all the people that pay in money into your bank account or those you pay money to.
4. Set up Project Locations (Branch, Department of Division Locations)
5. Set up Cash and Bank Accounts  for operations
6. Process, record Payment Vouchers and update to the Cash & Bank books
7. Record and update all bank inflows into the Cash & Bank books
8. Generate Payment reports for Expenses, liabilities and Assets paid for
9.Generate Receipts reports for all inflows recorded
10. Generate Reports based on Locations and Projects (Branches/Departments/Divisions)
11. Generate Reports based on Account Chart (Account Groups & Account Head)
12. Do much more based on your operational need and customization request.

These video tutorials will help you to understand how the template work.

PART 1 VIDEO


In this Part 1 video tutorial: 1. Introduction to the Template: 0:34​ 2. Template overview & set up: 2:41​ 3. Set up Projects or Branches: 6:12​ 4. Set up operation's cash & bank accounts & update Chart of Accounts: 6:43

PART 2 VIDEO



In this Part 2 video tutorial: 1. Bank Names and Code Set up: 1:07​ 2. Account Chart Mapping: 1:24​ 3. Set up types Partners: 4:35​ 4. Set up locations: 5:00​ 5. Upload Partners' Data: 5:18

PART 3 VIDEO



In this Part 3 video tutorial: 1. Explaining the Pivot table filed list: 0:50​ 2. Changing report filter criteria: 1:27​ 3. Filtering report by year: 4:12​ 4. Filtering report with slicers: 4:40​ 5. Inflow Report: 7:12


PART 4 VIDEO





In this Part 4 video tutorial: 1. Explaining the Payment Schedule Template: 0:45​ 2. Printing the Payment Schedule: 9:35​ 3. Creating a PDF file for the payment schedule: 10:05​ 4. Checking the Cash & Bank Book: 11:09​ 5. Refreshing Reports: 12:40


PART 5 VIDEO



In this Part 5 video tutorial: 1. Record Inflows: 0:37​ 2. Bulk Online Bank Payment: 5:00

PART 6 VIDEO


In this Part 6 video tutorial: 1. How to use the PETTY CASH Sheet: 0:40​ 2. Weekly summary: 6:00

If you are interested in the demo file, kindly contact us via REQUEST DEMO.

You may be interested in seeing our pictorial tutorial on Some Business & Accounting terms on CASH

You can make suggestions on any Template that you want us to work on using Microsoft Excel Application. 


Comments

Post a Comment