View Project or Customer Profitability in Zoho Books

As a growing business, you would have a rapidly expanding customer base spread across several domains and locations. It becomes confusing when you generate a report, as it fetches information about all the customers. Zoho Books allows you to generate filtered reports based on short keywords called Reporting Tags.

You can create and associate Reporting Tags with transactions created in Zoho Books. Once you associate the tag(s) with multiple transactions over a period of time, it will be easy for you to generate reports for transactions based on the particular tag(s).

Let us consider an example where you have a lot of business coming from different car rental companies. Whenever you create an invoice for such companies, you can associate a tag say, ‘Car Rental’ to it. Later on, if you’d like to look up transactions made for car rental companies, all you have to do is generate a financial report based on the tag ‘Car Rental’. You can also go one step further to see your payables and receivables based on say, your Region. You could add location tags such as New York, Texas, California, etc., to see transactions that have been created for customers in these regions.

Create a Reporting Tag

• To create a reporting tag, click on the Gear icon on the top right corner of your Zoho Books screen.

• Navigate to More Setting -> Reporting Tags and click on the + New Tag button.

• In the pop-up that follows, enter the Tag Name.

• Under Options, you may enter the names of different cities, departments, categories etc. based on your requirement.

Click on Save to save the tag.

Associate a Tag with a Transaction

You can associate tags with Sales and Purchases transactions such as invoices an expenses. For example, while creating an invoice:

• Click on the small ‘Circle’ icon on the New Invoice screen next to the Item Amount column.

• Clicking on the icon will bring the Additional information pop-up where you can associate the tags you wish to for this transaction.

Click on Save to finish.

Associate a Tag with a Contact or Item

You can associate Reporting tags with a Contact or an Item and it will automatically get added to the invoice when the particular customer or the item is included in the invoice.

Associate a tag for a contact:

While creating/editing contacts, scroll down, select the Reporting Tags tab and choose one of the options for the reporting tags that you had created earlier.

Associate a tag for an item:

You can associate a tag while adding or editing an item in the Item Details screen.

Generate Reports

One of the most useful features of having reporting tags is the option to generate Business Overview reports including Profit and Loss, Cash Flow Statement and Balance Sheet based on the tags that have been created and associated to transactions.

• Navigate to the Reports module and select one of the reports under the Business Overview section.

• Select the Customize Report option under the search bar.

• You will see that the reporting tags that you have created are listed here. Select one of the options from the drop-down for each of these reporting tags.

Finally, click on Run Report to generate a report based on the criteria you’ve set.

#ZohoBooks