Small Business Finance Manager (Excel)

Which Excel versions are supported?
Microsoft Excel for Windows (2013 or newer) Microsoft Excel 365 Microsoft Excel Online Microsoft Excel for Mac (2016 or newer)  
Mon, 24 Aug, 2020 at 8:39 AM
Are there any limits?
33 sub-categories for Profit-Loss statement 5000 transactions by default 10 Accounts (Bank, Credit Card and Cash Accounts) If you would like to mod...
Mon, 24 Aug, 2020 at 8:48 AM
Initial Set up - Small Business Finance Manager
In the Settings sheet, please follow the steps outlined below. Step 1: Enter Company Name Step 2: Enter start date Step 3: Enter all your...
Sun, 30 Aug, 2020 at 9:26 AM
Entering Transactions
In the previous article, we saw the initial set up which involved 4 simple steps. We will continue from there.  STEP 5: Enter Transactions This is t...
Fri, 28 Aug, 2020 at 10:33 PM
Samples of Different Financial Transactions - Small Business Finance Manager
There are 14 different types of financial transactions that the Small Business Finance Manager Excel template supports.  Choosing the correct type of trans...
Fri, 28 Aug, 2020 at 10:32 PM
Dashboard - Small Business Finance Manager
DASHBOARD The Dashboard provides  Total net balance across all the accounts.  Latest balances in each of the different accounts you have Acc...
Mon, 24 Aug, 2020 at 9:11 AM
Profit & Loss Statement - Small Business Finance Manager
PROFIT & LOSS The template generates a dynamic automated Profit and Loss Statement, also called an Income Statement.  The Category we picked when e...
Mon, 24 Aug, 2020 at 9:07 AM
Cash Flow Report - Small Business Finance Manager
Cash Flow Report The template also provides an automated and interactive Cash Flow Report or Statement. There are four parts of information provided. ...
Sun, 30 Aug, 2020 at 9:25 AM
Insights - Small Business Finance Manager
INSIGHTS In addition to knowing the Profit & Loss situation and Cash Flow of your company, knowing what drives the sales and where the money is bein...
Wed, 26 Aug, 2020 at 7:47 PM
Unpaid Report - Small Business Finance Manager
UNPAID REPORT Unpaid Report allows you to see Unpaid Invoices or Unpaid Bills. A screenshot of Unpaid Invoices is below. Invoices Not Due Yet an...
Mon, 24 Aug, 2020 at 9:31 AM