Download Merchandising Business Accounting Excel Template


Popular Categories in Excel Template
Trednding in Excel Template

Child Tax Credit Calculator

Child Tax Credit Calculator is an excel template that help you to easily calculate your …

Read More

Construction Schedule

This construction schedule template is design to provide a very simple way to create a …

Read More

Income Statement

Download Income Statement Excel Template to monitor your incomes sources The income statement displays information …

Read More

Employee Termination Letter

Employee Termination Letter is a ready-to-use excel template that helps you to prepare termination letters …

Read More
Generic filters

Merchandising Business Accounting is a type of business where particular companies or entities purchase inventory from other companies and resell it to get some profit. Stores that you see in every cities fall under this category. You can categorize them as distributor, agents or resellers, depending on their company or inventory size. This Accounting for Merchandising Business spreadsheet is a tool to help you record and summarize your trading/retail transactions in Microsoft Excel.

Merchandising Accounting

Cost of Goods Sold (CoGS) is a key term that differentiates this type business with other models. You won’t meet with this term in Service companies. You will get this term in Manufacturing companies, but it doesn’t come from purchasing from other companies. It comes from the combination of raw material cost and factory overhead. Then, you put profit on top of this cost to cover all of your expenses.

Merchandising Income Statement

In general, companies who bought it from manufacturing companies and in bulk quantity get the best price where they can put proper margin to sell to other companies. Many companies fall to this category, because it is easy to buy and sell things. They don’t have to think about developing their own products. They just think about how to distribute and sell them as many as possible to get maximum profit.

Accounting Cycle of a Merchandising Business

Accounting Cycle for Merchandising Business

This Accounting for Merchandising Business spreadsheet is one of the tool you can use to summarize your trading and retail businesses.

There are main parts in the spreadsheet where you will work frequently to record your transaction.

Accounting for Merchandising Business – Chart of Accounts Setup

This is an initial page where you can put your company identity and chart of accounts that you can use in your company frequently. Chart of Accounts codes can be used as main references in all worksheets inside this spreadsheet. Different type of business could have different Chart of Accounts codes format.

Accounting Journals

There are general journal and special journals where you can log your financial transactions. Special journals consist of cash, sales and purchase journals. You might find different journal classification in some accounting software but you don’t have to worry about it. It is just a method to log the transaction to into journals. Sometimes you will find merchandising companies have more than three special journals, for example, separating cash journals into cash-in and cash-out journals. Also, there are companies that only write all of their transaction in one general journal only.

In this Accounting for Merchandising Business spreadsheet, you can classify and write all of your transaction as follows :

  • General Journal : All non cash transaction that are not parts of Sales and Purchasing transaction
  • Cash Journal : All cash transaction including sales and purchasing transaction
  • Sales Journal : All sales transaction excluding cash transaction
  • Purchase Journal : All purchase transaction excluding cash transaction

Financial Report

There are four main financial report you can generate from journals. It is as easy as selecting respective chart of account codes in each report format worksheet. Then, you will get them printed in report worksheet with formal layout.

  • Profit and Loss Report : To show your company profit and loss situation. You can see them in month visualization as you can see in screenshot below.
  • Balance Sheet : To show your company financial health condition. You can monitor them in month display as well and analyze whether your assets tend to increase or decrease over months.
  • Cash Flow Report : This one to show you your company cash flow situation. This is the easiest parameter to see since you can see them physically.
  • Equity Report : To show your investors or yourself status of your investment

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Merchandising Business Accounting Excel Template

Instruction :

All Excel templates and tools are sole property of User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: