Power BI Fast Close Report in Month-End Closing Accruals

How can I use the Fast Close Power BI report in conjunction with D365 Finance General Journals for month-end closing accruals?

Accurate and efficient processing of month-end closing accruals in D365 Finance is crucial for maintaining financial integrity. This guide provides a description for the Fast Close report, as well as step-by-step instructions on setting up D365 journal Excel templates, modifying journal lines, and ensuring proper data upload for seamless month-end closing. Dooap's Power BI Fast Close Report can be utilized as a template in Month-end Closing Accruals.

Important: When setting up the D365 journal Excel templates, it is crucial to carefully follow the instructions for file naming and dimension setup in D365.

Fast Close Report

The Dooap Analytics Power BI offers a report called Fast Close, designed to streamline your month-end accruals. You’ll find it under AP Tools within Dooap Analytics.

The report focuses exclusively on coding lines from invoices that haven’t yet been transferred from Dooap. These include invoices with statuses:

• "New"
• "In Workflow"
• "Approved".

For Ledger PO and Project PO, the report only shows invoices that are 2-way matched.

When selecting a posting date range, keep in mind:

• The earliest date available corresponds to the company's oldest non-transferred invoice in Dooap.
• Ongoing months will only appear once the month has closed (e.g., January 2025 becomes available for selection in early February 2025).

By focusing on untransferred invoices, the Fast Close report gives you a head start on closing the books.

Processing Month-End Closing Accruals

To process month-end closing accruals, you can use any General Ledger journal type in D365 Finance.

1. Open D365.
2. Begin by creating a new journal.
   1. When using the journal for the first time, it's recommended to manually fill in one line to understand the format of each field when opening the journal in Excel.
3. To modify the journal, select it and click Open lines in Excel.
4. In the dialog box, choose the template you want to use.
   1. 1. You can select the Microsoft default "General journal line entry" template or a custom template like "Dooap FastClose".
      2. New custom templates can be uploaded via Common > Office Integrations > Document templates.
      3. More information on adding custom templates can be found here. 
         
         
         
         
         
         
         
         
5. Open the downloaded Excel document.
6. In Excel, click Enable Content to activate the Add-In.
   1. If this is your first time using the Excel Add-In, you may need to enable it by clicking the Insert tab in the Excel ribbon, selecting "My Add-ins," and then choosing the Microsoft Dynamics Add-In.
      1. Click Add to open the side panel, which will indicate the connection to D365.
   2. If prompted, enter your D365 login credentials.
      
      
      
      
      
      
      
7. You can now modify the journal lines.
   1. Keep in mind that D365 is very strict about the coding format; you must ensure the correct number of values or delimiters are used.
      1. Do not manually change the "Line Number" field.
8. To upload the lines to the journal in D365, click Publish in the lower right corner of the D365 Add-In screen.
   1. Be aware that any lines with errors will be removed during the upload, so it's advisable to save a backup of the lines before publishing to avoid additional work.
      
      
      
      
      
      
      
      
9. Any upload errors can be viewed via the flag icon.
10. Once the publishing is completed, you can close the Excel file.
11. The lines are then visible inside the journal in D365.