Articles in this section

Create and Post Journal Entries (Adjustments) for Statements

This article outlines how MDFM administrators create and post journal entries in the Governmental, Proprietary and Fiduciary data models for a fund category during the year-end reporting process. This should be done after mapping all accounts in these data models. 

Create and Post Journal Entries Walkthrough

Select Next to move through the guide. You can also zoom in and out of the image by selecting the Magnifying Glass in the bottom right-hand corner. You can view the full guide by selecting the External Link icon. 

Step-by-Step Instructions

Create the First Adjustment

  1. After mapping all unmapped accounts in a Statement data model, click Adjust.
    • Important Note: Adjustments made to fund are made at the GL level and will reflect in all statements tied to the same GASB fund category.
  2. Click Select Type and select Adjustment
  3. Click the Statement Structure field and select the specific area of the statement to apply the adjustment.
  4. Click Reporting Funds and select the specific Fund to apply the adjustment.
  5. The period will already be selected based on the period set on the Map section. 
  6. Click Select Transaction
  7. Select the top row that has "JE" in the majority of the columns to create a new Journal Entry.
    • Note: You may see additional rows. These are previously created journal entires to that fund.
  8. Click the icon with an A with box under it that highlights the attributes blue.
    • This shows the details/attributes that need to be added to the adjustment for it to be automatically be mapped to the government wide statements. Add the appropriate attributes to the blue columns. Use local rules as your guide. 
  9. Enter in the adjustment for this Fund and click Enter or select the Save (Floppy Disk) icon.
    • Note that at the bottom of the section, you will see the number you just entered in orange. This is because we need to balance the journal entry with an offsetting transaction.

Create the Offsetting Adjustment

  1. Change the filters as needed to create the offsetting transaction.
  2. Click Select Transaction when ready.
  3. Select the Journal Entry row.
  4. Enter in the balancing amount to the entry and click Enter or the Save (floppy disk) icon to confirm.
    • Note now the table is balanced and can be posted.
  5. Select Post Transactions.

Review the Adjustment

  1. After posting, you will want to remove the filtering created from creating the transaction to confirm everything is in balance. Select a field and select the X to remove a filter.
  2. Check the adjusted amounts column total to ensure it shows 0.



Have more questions or need assistance? Submit a Request

Related articles