Crafton Kennels is a small family business that provides boarding services for pets while their owners are away. They also have grooming faculties and limited pet care services. Because of the limited size of the business, maintaining awareness of cash is much more important than dealing with accrual accounting. To assist in this, the VBA program I wrote takes all cash deposits and withdrawals from the bank statements and creates a monthly cash statement. The program also asks the user to classify each expense (withdrawal transaction). It then sums the expense totals to be provided in the statement. Additionally, it common sizes the statement, taking relevant line items and dividing it by total revenue which highlights the leading cash sources and expenses. Finally, the workbook contains a year to date tab that sums line item amounts from all existing statements, giving the business owners a feel for their performance for the current time period of the year.
Thursday, December 8, 2011
Cash Statements for Crafton Kennels
Crafton Kennels is a small family business that provides boarding services for pets while their owners are away. They also have grooming faculties and limited pet care services. Because of the limited size of the business, maintaining awareness of cash is much more important than dealing with accrual accounting. To assist in this, the VBA program I wrote takes all cash deposits and withdrawals from the bank statements and creates a monthly cash statement. The program also asks the user to classify each expense (withdrawal transaction). It then sums the expense totals to be provided in the statement. Additionally, it common sizes the statement, taking relevant line items and dividing it by total revenue which highlights the leading cash sources and expenses. Finally, the workbook contains a year to date tab that sums line item amounts from all existing statements, giving the business owners a feel for their performance for the current time period of the year.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment