Financial Reports

Financial reports provide a comprehensive overview of your business activity. The module is organized in four tabs: Sales, Expenses, VAT and Aged Balance.

Required Setup

IMPORTANT: Financial reports depend entirely on your fiscal period configuration. This must be set before you can view any reports.

Configure the Fiscal Period

1. Go to Company > Settings > Tax Information
2. Select your Fiscal Period:
   • Monthly: Reports by month (recommended for most businesses)
   • Quarterly: Reports by quarter (for larger companies)
3. Save the configuration

Without this configuration, no reports can be generated.

Sales Tab

The Sales tab displays payments received on your invoices:

• Total Invoiced: Total amount of issued invoices
• Total Payments: Total amount of payments received
• Tax Collected: VAT collected on sales (for VAT-registered companies)
• Trend Chart: Evolution over multiple periods
• Detailed Table: Breakdown by invoice and client

Multi-Currency Support

If you invoice in multiple currencies:

• Amounts by Currency: Totals displayed in each currency used
• Automatic Conversion: All amounts converted to your main currency

Expenses Tab

The Expenses tab summarizes your purchases and expenses by category:

• Total Expenses: Total amount of recorded expenses
• Total Paid: Amount of expenses actually paid
• Recoverable VAT: Deductible VAT amount on your purchases
• Breakdown by Category and Supplier: Detailed view of your charges

VAT Deductibility on Expenses

Each expense has a VAT recoverable indicator:

• By default, deductibility is inherited from the expense category
• You can change it individually when entering an expense
• Only expenses marked as “VAT recoverable” appear in the VAT report (section C)

VAT Tab - SIMPL Declaration

This feature requires a Pro or Premium subscription.

The VAT report presents your VAT declaration following the official SIMPL format from the DGI (Moroccan tax authority). It is available only for Moroccan companies registered for VAT.

Report Structure

The report follows the sections of the official VAT declaration form:

A/ Total Revenue Breakdown

Breakdown of your total revenue excluding tax:

• Line 10: Total revenue including non-taxable operations (excl. tax)
• Line 20: Operations outside VAT scope
• Line 30: Exempt without deduction right (art 91 CGI)
• Line 40: Exempt with deduction right (art 92 CGI)
• Line 50: Suspended VAT operations (art 94 CGI)
• Line 60: Taxable revenue (calculated automatically)

B/ Taxable Revenue by Rate

Tax due broken down by VAT rate (20%, 14%, 10%, 7%):

• Tax base excluding tax for each rate
• Corresponding tax due
• Line 130: Total tax due

C/ Deductible VAT

Recoverable VAT on your expenses:

• Breakdown by VAT rate of deductible expenses
• Line 170: Previous period credit (carried forward automatically)
• Line 190: Total deductible VAT

E/ Declaration Summary

Final summary of your declaration:

• Line 200: VAT due (line 130 - line 190) if collected VAT exceeds deductible VAT
• Line 201: Credit to carry forward if deductible VAT exceeds collected VAT
• Line 202: 15% reduction of the period credit
• Line 203: Remaining cumulative credit after reduction

Download EDI File for SIMPL-TVA

The Download Deduction Schedule (ZIP) button generates a file in EDI format compatible with the DGI’s SIMPL-TVA portal.

To import the file:

1. Select the desired period in the VAT report
2. Click the download button
3. A ZIP file containing the XML is downloaded
4. Log in to the DGI’s SIMPL-TVA portal (simpl.tax.gov.ma)
5. Import the ZIP file in the “Deduction schedule” section

The EDI file contains:

• Your company identification details (ICE, IF)
• Details of each deduction (supplier, amount excl. tax, VAT, invoice number)
• The declaration period

Requirements

The VAT report and EDI export are available when:

• Your company is registered in Morocco
• Your company type is VAT-registered (SARL, SA, SNC, etc.)
• The fiscal period is configured (monthly or quarterly)
• You have invoices and/or expenses for the selected period

Aged Balance Tab

This feature requires a Pro or Premium subscription.

The Aged Balance tab lists all customer invoices with an outstanding balance, grouped by how overdue they are relative to their due date. It lets you quickly identify at-risk receivables and prioritise follow-up on the oldest outstanding amounts.

”As of” Date

The As of date field sets the reference date for the calculation. It defaults to today. By changing this date you can reconstruct the balance as it stood on any past date: only payments received before the chosen date are counted; later payments are excluded.

Aging Brackets

Each unpaid invoice is assigned to one of five brackets:

Bracket	Definition
Not yet due	Due date not yet reached as of the reference date
1 – 30 days	1 to 30 days overdue
31 – 60 days	31 to 60 days overdue
61 – 90 days	61 to 90 days overdue
> 90 days	More than 90 days overdue

Receivables Table

The table shows one summary row per customer, which can be expanded to display the individual invoices. Sub-totals per currency are shown separately; a grand total converted to the company currency appears at the bottom.

Summary Statcards

Four key indicators are displayed at the top of the page:

• Total due: Total outstanding receivables, with the number of customers involved
• On time: Amount of invoices not yet due (the “Not yet due” bracket)
• Overdue: Combined amount across all overdue brackets
• High risk > 30 d: Amount overdue by more than 30 days (brackets 31-60, 61-90 and > 90)

Each statcard also shows what percentage of the total due that amount represents. Statcard amounts are expressed in the company currency.

Multi-Currency Support

Each invoice is displayed in its original currency. Per-currency sub-totals let you track receivables currency by currency. The grand total at the bottom of the table provides a converted figure in the company currency for a consolidated view.

Note: The supplier aged balance is not yet available in this version.

Period Selector

The Sales, Expenses and VAT tabs share the same period selector:

• Monthly: Data for a specific month
• Quarterly: Data for a quarter (Q1, Q2, Q3, Q4)
• Annual: Consolidated view for the entire year
• Navigation: Arrows to change period or year

The Aged Balance tab does not use this selector. It shows an “As of” date field instead, which serves as the single reference date for calculating outstanding receivables.

Best Practices

• Regularly check consistency between your sales and expenses
• Correctly mark VAT deductibility on each expense
• Download the EDI file before the declaration deadline
• Keep a copy of your reports for your accounting records

Troubleshooting

Common Issues

“No VAT data for this period”

1. Verify your company is Moroccan and VAT-registered
2. Make sure you have invoices or expenses for the period
3. Check the fiscal period configuration

EDI download button does not appear

• The button is only visible for Moroccan VAT-registered companies
• Check your company type in settings

Inconsistent data

1. Verify payment entries
2. Check exchange rates (multi-currency)
3. Review VAT deductibility settings on your expenses

Aged balance shows no receivables

• Verify you have an active Pro or Premium subscription
• Make sure there are customer invoices with a positive outstanding balance
• Check the “As of” date: if it is earlier than all invoice due dates, the balance will be empty

Statcard amounts differ from the table

• Statcards are always shown in the company currency (with automatic conversion)
• The table keeps each invoice amount in its original currency

---

Need help? Contact our support team.