ASQiT

FINANCE MONTH END

ACTIVITIES

DASHBOARD

User Guide

Description

This document provides a guide to the Finance Month End Activities app, and how to get the best out of its

functionality.

Visit our web page to learn more

2

App Description

The Finance Month End Activities Dashboard app for Microsoft Dynamics 365 Business Central is a

dashboard of a few finance activities that are usually completed at the finance month end:

Journals (including recurring journals) to post,

Fixed assets to depreciate,

Bank entries to reconcile,

VAT entries to settle,

Currencies to adjust.

The dashboard displays the number of activities to do for the month end date:

The dashboard is included in following role centres:

Accounting Manager

Business Manager

Bookkeeper

Accountant

The dashboard can be moved or removed using standard personalization of Business Central role

centre.

Important. All outstanding

activities are shown for the

Period End date. For

example, unposted journals

with posting dates after

Period End date are not

included in this dashboard.

Figure 1 - Finance Month End Activities Dashboard

3

Using the Dashboard

The Finance Month End Activities dashboard gives user a quick access to specific areas to finish or

review outstanding activities. By clicking the number of activities on the right hand side of the

dashboard, system opens the related page.

Journal Lines to Post

‘Journal Lines to Post’ shows unposted General Journal lines, with the Posting Date on or before the

Period End, with amounts not equal to zero. Click on the number to open the list of journal batches.

The page will display:

- Journal Template, Batch Name and Description with journal lines to post.

- Number of Unposted Lines for this particular batch.

- Total Debit and Total Credit for this particular batch.

Following options are available:

- Edit Journal. Opens the selected journal to review/change or post.

- Open Journal Batches. Opens the list of batches for the selected template

Figure 2 - Journals to Post

4

Recurring Journal Lines to Post

‘Recurring Journal Lines to Post’ shows unposted recurring General Journal lines, with the Posting

Date on or before the Period End. This part includes lines with zero amounts. Click on the number to

open the list of journal batches. The page will display the same information and options as in non-

recurring journal page.

Fixed Assets to Depreciate

Figure 3 – Recurring Journals to Post

Figure 4 - Fixed Assets to Depreciate

5

‘Fixed Assets to Depreciate’ shows the number of active Fixed Assets that need to be depreciated in

the period. Click on the number to open the list of fixed assets. The page will display:

- Fixed Asset Number, Depreciation Book Code, Depreciation Method and FA Posting Group

for the given fixed asset.

- Current Book Value for this particular fixed asset.

- Ending Book Value/Salvage Value.

- Last Depreciation Date to show when was the depreciation last recorded for this fixed asset.

Following options are available:

- Fixed Asset Card. Opens the selected fixed asset card.

- Ledger Entries. Opens ledger entries of the selected fixed asset.

- Calculate Depreciation to calculate the depreciation for the period.

- FA G/L Journal. Opens the FA GL journal, used when Deprecation book is integrated with GL.

- FA Journal. Opens the FA journal, used when Depreciation book is not integrated with GL.

Bank Entries to Reconcile

‘Bank Entries to Reconcile’ shows the number of open bank ledger entries that need to be reconciled

for the period. Click on the number to open the list of bank accounts with unreconciled entries. The

page will display:

- Bank Account Number, Name and Currency Code of the bank account.

- Current Balance and Balance at Date for this particular bank account for the period end.

Figure 5 – Bank Entries to Reconcile

6

- Balance to Reconcile shows the total amount of open ledger entries.

- Entries to Reconcile show the total number of open ledger entries for the bank account.

Following options are available:

- Bank Account Card. Opens the selected bank account card.

- Statements. Opens posted Bank account statements for the selected bank account.

- Ledger Entries. Opens all ledger entries of the bank account.

- Bank Account Reconciliations. Opens the page to start the bank account reconciliation.

VAT Entries to Settle

‘VAT Entries to Settle’ shows the number of open VAT entries that need to be settled for the period.

Click on the number to open the list of VAT Posting Group combinations with open entries. The page

will display:

- VAT Bus. Posting Group and VAT Prod. Posting Group as the combination of posting groups

with open VAT entries.

- Amount to Settle shows the total amount of VAT from open entries.

- Amount (Base) to Settle shows the total base amount from open VAT entries.

- No. of Entries to Settle shows the total number of open VAT entries for the period.

Following options are available:

- Calc. and Post VAT Statement. Calculate and post VAT settlement.

- VAT Statement. Opens the VAT statement reports.

- VAT Entries. Opens the VAT ledger entries.

Figure 6 – VAT Entries to Settle

7

Currencies to Adjust

‘Currencies to Adjust’ shows the number of currencies that haven’t been adjusted in the period and

have at least one open entry or bank account. Click on the number to open the list of currency codes

that needs adjusting. The page will display:

- Code and Description of the currency.

- Last Date Adjusted shows the date currency was last adjusted.

- No. of Cust. Ledger Entries shows the number of open customer ledger entries with the

currency, posted before the end of the period.

- No. of Vendor Ledger Entries shows the number of open vendor ledger entries with the

currency, posted before the end of the period.

- No. of Bank Accounts shows the number of bank accounts with this currency.

Following options are available:

- Exchange Rates. Opens the list of exchange rates for this currency.

- Adjust Exchange Rate. Runs the currency exchange rate adjustment job.

- Exchange Rate Adjust. Register. Opens the exchange rate adjustment register.

- Update Exchange Rates. Calls automated currency exchange rate upload, if it is configured.

Figure 7 – Currencies to Adjust

8

Defining Period End

The Finance Month End Activities app for Microsoft Dynamics 365 Business Central works out

outstanding activities based on the calculated Period End. System finds which period the specific

user is working on, based on the calendar setup, work date and allowed posting periods.

If user is allowed to post to the previous accounting period, then system will set Period End as the

end of the last accounting period.

Click on the Period End date to open the review of allowed dates and accounting period setup:

Figure 9 - Period End calculation

The page displays:

- Allow Posting From and Allow Posting To shows the posting dates set on the General

Ledger Setup. Click on the General Setup to view and change those dates.

- User Allow Posting From and User Allow Posting To shows the posting dates set on the User

Setup. Click on the User Setup to view and change those dates.

- Last Period Start, Current Period Start and Current Period End shows dates set as

Accounting Periods. Click on the Accounting Periods to view those dates.

It is very important to manage

Allow Posting From and Allow

Posting To on the General

Ledger Setup or User Setup,

for the system to calculate

Period End correctly.

Figure 8 - Period End on the Finance Month End Activities dashboard

9

System Setup

There is no specific setup required for Finance Month End Activities dashboard.

Users do not require any additional permission. Dashboard will show the outstanding activities for

anyone that uses specified Role Centres, but will only display activities based on user’s permissions.

Additional links to open Bank Accounts, VAT Entries, etc. will also use standard user permissions to

these areas.