← All prebuilt solutions
Management Accounts & Reporting

FreeAgent Dashboard

Paste your FreeAgent transactions export – get a monthly profit and loss, year-on-year comparison and charts

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

FreeAgent Dashboard

Overview

FreeAgent is great for bookkeeping but its reports are one period at a time. This workbook takes an export of your transactions and builds a monthly profit and loss for the whole year, compares it with last year, and charts it – ready for a board pack, a bank or your own review.

Price
£20
Who it’s for
Management Accounts & Reporting
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Data

Your pasted FreeAgent export. What you do: paste each month.

Data
Category Map

Step 2

Category Map

How each FreeAgent category is reported. What you do: check the mapping once.

Step 3

Monthly

Profit and loss month by month. What you do: nothing to enter.

Monthly

Step 4

Who it is for

Made for people like you

  • Example – text
  • FreeAgent users – Better reporting from your existing bookkeeping.
  • Contractors and freelancers – See profit month by month without extra work.
  • Accountants – A quick management pack for FreeAgent clients.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Your business name and the first month of your financial year. Say whether money-out amounts appear as minus figures in your export.
  2. Export from FreeAgent – In FreeAgent go to Accounting → Transactions, choose a date range covering this year and last year, and export to CSV (or use any report that lists each transaction with its date, category, description and amount).
  3. Data – Paste the Date, Category, Description and Amount columns into the yellow columns – paste values only (Paste Special → Values).
  4. Category Map – Check every category has a report heading. Anything not on the list shows as "Not mapped" – add it at the bottom of the map.
  5. Dashboard – Your results. Monthly has the full profit and loss.

Key features

  • Turns a FreeAgent transactions export into a month-by-month profit and loss for your financial year, with last year alongside.
  • Maps every FreeAgent category to a report heading – you can change any of them, and lines that are not mapped are flagged.
  • A one-page dashboard: income, gross and net profit, margins, a monthly chart and where the money goes.

What’s included

  • Dashboard – Your figures at a glance
  • Monthly – Month-by-month profit and loss
  • Data – Paste your export here
  • Category Map – Category → report heading
  • Settings – Business name and year start
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions