Ensuring that you keep accurate records to produce financial statements such as balance sheets, income statements, expense reports, and more, is important to help internal and external stakeholders make essential business decisions.

To get started quickly, it may be helpful to use a familiar Excel accounting template. But, with all the templates out there, how will you know which one is best for you? An accounting journal is an accounting worksheet that allows you to track each of the steps of the accounting process, side by side.

This accounting journal template includes each step with sections for their debits and credits, and pre-built formulas to calculate the total balances for each column. Every company should have a process in place to manage the outstanding balances owed to them.

A bill of lading is a document detailing how goods are being shipped from a seller to a recipient. It includes details about the items being shipped, the quantity of items included in the shipment, and the destination address.

Use a bill of lading template to ensure you complete this document for each shipping transaction. This template includes a signature section that should be signed by you, then the shipping company, and finally the recipient, so that if the shipment is lost, the signature detail will help identify at what point it was lost and who was liable.

A billing statement is helpful if you receive regular bi-monthly or monthly payments from your customers. Use this billing statement template to track customer invoices, account details, and billing status, all in one location. A cash flow statement is important to provide a good picture of the inflow and outflow of cash within your company.

It shows where the money came from cash receipts and where the money went to cash paid. Use a cash flow statement template, in conjunction with your balance sheet and income statement, to provide a comprehensive look into the financial status of your company. This cash flow template includes two additional worksheets to track month-to-month and year-to-year cash flow. It enables you to estimate how much money your business will make and spend at any given point, and will allow you to take the appropriate steps to ensure that your cash outflow is not more than your inflow.

Use a simple cash flow forecast template to get started quickly. Be sure you include all income including revenue and investments, and account for all expenses including fixed costs. A simple expense report is helpful to keep track of business expenses for an individual, department, project, or company, and provides a quick way to document and track expense details.

You can require that your team submit monthly expense reports or as the expenses are accrued. Use this expense report template to quickly input specific expense details and obtain approvals as needed.

An income statement, or profit and loss statement, provides a look into the financial performance of a company over a period of time. You will likely have multiple bills to pay in a month, to different companies and on different dates. It is important to have a way to track when specific bills are due, the amount that is due, and to whom. Use a simple payment schedule template to track these details. This payment schedule template will help you remember when each bill is due and be able to budget accordingly.

Cash Flow Statement Template for Excel - Statement of Cash Flows

Use a simple business travel itinerary template to keep all of these details in one location, and be able to share the details with important stakeholders. Smartsheet is a spreadsheet-inspired work management tool with robust collaboration and communication features. Its pre-built accounting templates make it even easier to create reports, track progress, manage documentation, and quickly organize the details. And, Smartsheet offers robust templates that makes it simple to get started right away and share status with your team.

Gantt charts are automatically created and auto-adjust every time you change task information, so there is little setup required when you want to visually show progress. You can easily switch between spreadsheet, Gantt, and Calendar views with team members or external collaborators, without emailing static spreadsheets back and forth.

Try Smartsheet Free for 30 Days. Submitted by Cherilyn B. Submitted by Philip Chidumay Contact Us or call 1 All Rights Reserved Smartsheet Inc.

Skip to main content. Top Excel Templates for Accounting Try Smartsheet for Free. Accounting Journal Template Accounts Payable Template Accounts Receivable Template Bill To Invoice Template Bill of Lading Template Billing Statement Template Cash Flow Statement Template Cash Flow Forecast Template Expense Report Template Income Statement Template Payment Schedule Template Simple Balance Sheet Template Travel Itinerary Template Save Hours of Manual Work with Smartsheet Share.

Bill To Invoice Template. Bill of Lading Template. Cash Flow Statement Template. Cash Flow Forecast Template.

Simple Balance Sheet Template. Save Hours of Manual Work with Smartsheet Smartsheet is a spreadsheet-inspired work management tool with robust collaboration and communication features. I was looking for a way to help my husband manage the financial aspect of his business.

I wish to save all of these to one spreadsheet if possible.

Thanks I found AP Ledger very Helpful in my current AP position. I would like to thank you for the reviews and provision of these information. It is very important and I am now using these templates to run my preschool.

Usful formates for accounting team.. These are easily understandable and simple to do effectively. Greatly thank you I appreciated.

Cash flow statement - Office Templates

Thank you for all the information it would be a big help for my job as basis and step to start. Continue to share and bring knowledge to people.

Thank you for such time saving resources. What will the world be without the goodness and unselfishness of others. I got the things that I have been looked for and very helpful to me. I still have no clue where to start with a general ledger. So I googled templates came across your site. The sign of relief came over me. I'm even more excited now than ever to start my business venture. With these templates I can keep track of my accounts credits, debits, payables, and receivables.

God bless you for helping those such as me who are challenged with this type of task. You made my life easier. This is a very wonder tutorial with supported package for good undertaking that would result in a better production and profit. This is really helpful. I just found all i needed for simple project book keeping and accounting basics. This is very good and useful.

Thanks a lot as this will help me improve my financial management tasks at the position. Its helpful for all financial analysis. Company About Us Customers Newsroom Blog Careers Partners. Apple iOS Google Android.