logo
logo

How to Create a Trial Balance by Period in Excel with Monkeymetric

Monkeymetric

Aug 12, 2023

7 min

Monkeymetric

Aug 12, 2023

7 min

A trial balance is an essential part of accounting, which gives you a great deal of insight into the company's monthly financials. In this tutorial, we'll guide you through the process of creating a trial balance by period using Excel and Monkeymetric. For a walkthrough of how to create the trial balance by month, please watch the video tutorial below:

What You'll Need

  • Microsoft Excel

  • Monkeymetric

How to set it up with our Excel template

1. Open Excel Template

To quickly setup the report, use our prebuilt template. Start by downloading the Excel template.

2. Connect to Monkeymetric

Open Excel, go to the 'Home' tab, look for Monkeymetric and click 'Launch'. Log in with your credentials and connect to 'Exact Online'.

3. Select your Division & Refresh Data

Navigate to the 'Refresh' tab. Here you will find the 'Transaction Lines' report. Click on it to open the report details. Click 'Modify' and select the entity for which you would like to setup the report. By clicking on 'Save' the report will automatically refresh. the Refresh Icon to load your Exact Online data instead of the example data.

4. Update The Pivot Table

Navigate to the 'Trial Balance By Period' sheet and select the (Pivot Table) Report. A new Ribbon Tab will be displayed called 'PivotTable Analyze'. Please navigate there and click on 'Refresh'. The report should now be updated with your data.

PRO TIP: If you double click a value in the table, it will show you the underlying financial transactions.

Conclusion

Creating a trial balance by period in Excel with Monkeymetric is a straightforward process that can be a great asset for controllers, accountants and business owners alike. With the Excel template and video tutorial provided, you'll have all the tools you need to get started.

Feel free to reach out with any questions or comments!

Join the reporting revolution.

Get started for free, no credit card required.

Get started for free, no credit card required.

Get started for free, no credit card required.