Cash Books & Budgeting with Excel

I want to download a friendly Excel file where I can keep a running total of my company cash balances without having to go online to look at our bank statement.

I want to budget our monthly cash flows and review variances within categories.

I need to differentiate cash transactions into categories and keep running monthly totals of all my receivable and payable accounts separated and totaled within each category.

(You have two options how to use Business Cash Books.)

You can enter cash receipts and payments as they happen and maintain a running cash book.

Alternatively you can enter receivable and payable items with forecast settlement dates and maintain a forecast cash book.

(You can do both by copying the file and creating a second cashbook).

I want to maintain escrow accounts so that I can park money earmarked for future expenses, taxes, insurances etc.

Create monthly budgets for each expenditure and credit category to see how we are managing compared to monthly budgets.

Help us control budget variance differences as new transactions enter our records.

Maintain detailed records in Excel so that I can look back to previous months and years and create budgets based on historical actual.

I dont want to have to buy new software to manage my money every year. I just want to set up a new Excel file to prepare our cash budgets each new year.

Investigate the option of registering as an affiliate to link people to our software, including Home Cash Books and Business Cash Books, My Loans Manager (cloud), Web Visitor Identity (cloud) and All Programs Excel Financial with an eCPM of $1,000 (Google Adsense eCPM $10-20). Earn 50% commission. Get directions from our email after ordering.

Suitable for PCs and Apple Mac and all versions of Excel.