We here at Spreadsheet123 have developed a series of customized Excel Spreadsheets and Templates designed specifically for Small Business. The spreadsheets are configured to organize
critical financial information generated by your business on a daily, weekly and/or monthly basis to forecast
trends and help with budgeting; and even to assist you in performing many types of "what if" analysis. But that's not all...many are
also designed to make manual entries into your accounting system more streamlined.
The information generated by these spreadsheets will allow you produce accurate monthly
financial reports and also support your efforts to proactively manage your business on a daily basis
Menu Cost Template calculates cost and profitability of the single menu item by summarising cost of all primary and secondary
ingredients used.
|
Monthly Profit and Loss Template for Excel contains five weekly P&L Workbooks
can be a real help when calculating your weekly and monthly profit and costs. It has an integrated budget tool that allocates estimated revenue,
profit and costs per set margin.
|
Beverage Stock Take Template for Excel that can help when counting amount of stock left on the shelf at the end of each week. The spreadsheet can also calculate your
growth profit and help to do your Beverage Weekly Key Line Checks to identify the amount of the stock loss.
|
Food Stock Take Template for Excel based on five weekly stock take workbooks that can calculate an amount of stock left on the shelf at the end of each week of the
entire month. The spreadsheet adds up all of your weekly deliveries and purchases and produces very
accurate end of the week totals.
|
designed to help product manufacturing businesses to make a business predictions for up to five years and with up to four products,
contains three main spreadsheets: Profit and Loss, Balance Sheet, Cash Flow and also Loan Repayment Calculator tool
combined together for more accurate business planning.
|
Purchase Order Template with integrated Instant Invoice tool for easy order management. This template can help when communicating with your customers or suppliers.
With few minor customizations you can create professional purchase order form that can also calculate delivery cost, discounts and tax.
|
The sales invoice includes shipping information, catalogue item number and special notes and instructions to you buyers. It also allows you specify
the payment terms, item quantities, tax rate and shipping and packing fees.
|
Service Invoice Template is designed to help small businesses and companies bill their customers for the service that they provide to them. (Eg. window cleaning, gardening or similar).
|
Service Invoice Template for Hourly Billing is specifically designed for businesses which bill by the hour or whose charges are based on
hourly rates. (Eg. solicitors firms, small broker companies or similar).
|
Service Invoice Template with Deposit Deduction is specifically designed for businesses that provide service to their clients and is very similar to our
Service Invoice Template and Service Invoice Template for Hourly Billing, but with added advance payment (Deposit) option.
|
Packing Slip Template is designed with small product selling business in mind. This template works very well together with our Sales Invoice Template
and Purchase Order Template.
|
Customer Account Statement Template for invoice tracking and easy customer account management and billing.
It can help to control your customers invoices and payments in one simple and easy to use document.
|