Month-End Accruals & Adjustments JEs Library – Excel File
55.59 $
Month-End Close Journal Entries Library: Provides standardized accrual, prepayment, depreciation, and provision entries, including usage rules, required support, and reversing entries. Delivers a unified reference to execute close adjustments consistently across teams.
Monthly Closing Journal Entries Library
Accruals + Prepayments + Depreciation + Provisions + Reversals + JE Log Lines + TB Impact Map
Value Proposition: A library of monthly adjustment entries in a repeatable format: Input Summary → JE Templates + JE Log → Adjusted TB → Closing Pack with documentation of “reason for entry/supporting document/period/reversal” instead of last-minute ad-hoc entries.
In 20 Seconds: What Will You Get?
- Accruals Templates: Accrued expenses/revenues with fields for “period/source/supporting document.”
- Prepayments Templates: Capitalization of prepaid expenses + amortization schedule + monthly entry.
- Depreciation Templates: Depreciation entry + linkage to asset schedule (FA Schedule) + reference.
- Provisions Templates: Creation/reversal/use of provisions with separation of “movement” from “balance.”
- Reversal Entries Templates: Identification of reversal entries (Auto/Manual) + reversal date + reason for reversal.
- Ready JE Log Lines: Reason for entry + supporting document + who prepared/reviewed/approved + impact on P&L/BS.
- TB Impact Map: Linking each type of entry to its accounts in the TB to reduce classification errors at closing.
CTA related to deliverables: Receive JE Templates + JE Log Pack to establish Adjusted TB and prepare Closing Pack with documented entries.
Suitable For
- GL Accountant executing recurring closing entries needing fixed templates and ready documentation.
- Head of Accounting wanting a unified JE Log + reversal plan to prevent repetition or omission of entries.
- Financial Controller needing clear impact of entries on TB delivered within the Closing Pack.
Not Suitable For
- Those wanting to “determine the numbers” on behalf of the team (the library provides templates, and the numbers come from your reports/contracts/schedules).
- Those without any supporting sources (contracts/invoices/FA Schedule/Payroll Summary) to justify accruals or prepaid expenses.
Without the Library / With the Library (Quick Comparison)
| Item | Without the Library | With the Library |
|---|---|---|
| Entry Formulation | Different entries based on person/month | Fixed JE Templates for each type (Accrual/Prepaid/Depreciation/Provision) |
| Reversals | Forgetting to reverse entries or repeating them | Reversal Plan specifies what is reversed and when/how (Auto/Manual) |
| Documentation | Reason for entry and supporting document are not standardized | Ready JE Log Lines: Reason/Supporting Document/Reviewer/Approver/Impact |
| Impact on TB | Classification errors appear after reports are issued | TB Impact Map links each entry to its accounts and reduces classification errors |
Before Use: 5 Symptoms of Closing Entries
- Accruals are recorded differently each month with no “template” linking the entry to the source.
- Prepayments are recorded as a full expense and then “corrected” later without a clear amortization schedule.
- Depreciation is entered as a total amount without linking to the asset schedule or movement of additions/disposals.
- Provisions are used/changed without separating the period movement from the balance or explaining the reason for the change.
- Reversal entries are forgotten or repeated because there is no record specifying “what is reversed and when.”
Monthly Closing Entries: Implementation Method (3 Steps Without Gaps)
Step 1: Preparation and Gathering Reports
- Extract TB/GL for the period and identify accounts needing adjustments (based on your business activity).
- Gather supporting sources: contracts/invoices/payment schedules, Payroll Summary, FA Schedule, any schedules for provisions.
- Determine if the entries are Reversal or non-reversal, and specify the reversal date.
Step 2: Prepare JE Templates + JE Log
- Select the appropriate template for each case (Accrual/Prepaid/Depreciation/Provision) and fill in the inputs.
- Create the entries and insert them into the JE Log: Reason for entry + supporting document + who prepared/reviewed/approved + impact of the entry.
- Update the Reversal Plan for reversal entries to ensure the reversal is executed in the following period.
Step 3: Adjusted TB + Closing Pack
- Issue the Adjusted TB after recording the entries and reviewing their impact using the TB Impact Map.
- Verify that reversal entries are recorded (Auto/Manual) and the reversal date is specified.
- Compile the Closing Pack: JE Log + entry attachments + any supporting schedules (Amortization/FA/Provisions) with clear indexing.
Library Components (Clear Inventory)
-
Accruals JE Templates
- Practical Purpose: Record accrued expense/revenue with specification of period, source of the amount, and required supporting document.
- When Used: Monthly before establishing Adjusted TB, often identified as reversal entries.
- Resulting Evidence: Documented entry + link/reference to the source (Invoice/Contract/Schedule).
-
Prepayments JE Templates + Amortization
- Practical Purpose: Transfer prepaid expense to an asset (Prepaid) and then amortize it monthly with clear schedules.
- When Used: Upon payment/start of the contract + monthly to record the amortization portion.
- Resulting Evidence: Amortization schedule + monthly entry linked to it + reference to the contract/invoice.
-
Depreciation JE Templates
- Practical Purpose: Record depreciation and link it to the asset schedule and movement (Additions/Disposals).
- When Used: Monthly or quarterly based on company policy, and annually as a minimum.
- Resulting Evidence: Depreciation entry + reference to FA Schedule or asset report.
-
Provisions JE Templates
- Practical Purpose: Create/reverse/use provisions with separation of period movement from balance.
- When Used: Monthly during periodic creation or when a situation arises requiring a provision, and annually for balance review.
- Resulting Evidence: Documented provision entry + movement schedule/basis of estimation (depending on the type of provision).
-
Reversal Plan
- Practical Purpose: A record specifying reversal entries: entry number, date of recording, reversal date, method of reversal (Auto/Manual).
- When Used: Monthly when entering Accruals and other entries requiring reversal.
- Resulting Evidence: Reviewable Reversal List preventing forgetting to reverse or repeating the entry.
-
JE Log Pack
- Practical Purpose: Standardize documentation of entries: reason + supporting document + reviewer + approver + impact of the entry on P&L/BS.
- When Used: With every adjustment entry within Month-End/Year-End.
- Resulting Evidence: Complete JE Log that can be delivered within the Closing Pack.
-
TB Impact Map
- Practical Purpose: Link each type of entry to standard accounts to reduce classification errors and review impact before closing.
- When Used: Before establishing Adjusted TB and after recording entries.
- Resulting Evidence: Impact map assisting the internal auditor in verifying the logic of classification.
-
Closing Pack Insert
- Practical Purpose: Compile closing entries and their attachments in one section within the Closing Pack.
- When Used: Monthly + annually when delivering the audit file.
- Resulting Evidence: Index of attachments linking each entry to the supporting document (Traceability).
CTA related to deliverables: JE Templates + Reversal Plan + JE Log Pack to establish Adjusted TB and deliver closing entries within the Closing Pack.
What Should Be Included in the Delivery?
- JE Templates File: Entry templates categorized by type (Accruals/Prepayments/Depreciation/Provisions/Reversals).
- Input Summaries: Sheet/summary of inputs for each entry: number/source/period/notes (Contract/Invoice/Payroll/FA Schedule).
- Amortization Schedules: Amortization schedules for prepaid expenses linked to monthly entries.
- FA Depreciation Support: Depreciation reference (FA Schedule or asset report) + movement of additions/disposals (if any).
- Provision Support: Basis estimation schedule for provisions (depending on type) + period movement (Opening/Movement/Closing).
- Reversal Plan: Record of reversal entries: ID/Date/Reverse Date/Method + execution status.
- JE Log: Complete entry log with reason for entry, supporting document, approver, and impact.
- TB Impact Map: Map linking entries to accounts for reviewing impact before establishing Adjusted TB.
- Closing Pack Insert: Index of entry attachments within the “JE” section of the Closing Pack.
After Implementation (Two Points Only)
- Operational Result for the Team: Month-End entries become repeatable: same template, same documentation fields, same reversal plan—reducing classification differences between months.
- Control/Audit Result (Evidence & Traceability): Each entry has a reason, supporting document, and reversal plan (if needed) and a place within the Closing Pack, traceable from JE Log to Adjusted TB without searching through disparate files.
FAQ — Questions Before Purchase
Is the library suitable for any accounting system?
Yes. Because the outputs are adjustment entries + JE Log + tie-out to TB. The only difference is how entries are input into the system.
Does it include reversal entries?
Yes. There is a Reversal Plan to specify reversal entries and how to reverse them (Auto/Manual) and the reversal date.
Does the library determine the numbers for me?
No. The templates specify the format and documentation. The numbers come from your internal sources (contracts, invoices, Payroll, FA Schedule, provision schedules).
Does it also cover year-end closing?
Very useful for Year-End as the same entries are repeated with stronger documentation. However, reclassification items or specific audit adjustments may require additions based on your situation.
Does it include provisions of all types?
It provides general templates for creating/reversing/using provisions with documentation fields. The type of provision and its measurement basis depend on your company policy and available data (claims/contracts/litigation, etc.).
Is it suitable for companies with fixed assets or without?
Yes. If there are no FAs, simply do not activate the Depreciation/FA Support templates, and the other templates remain usable.
Is there a template for delivering to auditors?
Yes. There is a Closing Pack Insert + JE Log Pack to compile entries and their attachments in one deliverable section.
Can it be applied within a small team?
Yes. The key is to commit to filling out the JE Log fields (reason/supporting document/approval) and updating the Reversal Plan even if the same person performs multiple roles.
Ready to Standardize Your Closing Entries and Document Them in the JE Log?
You will receive: Accruals/Prepayments/Depreciation/Provisions JE Templates + Reversal Plan + JE Log Pack to establish Adjusted TB and prepare Closing Pack.
| المسمّى الوظيفي | |
|---|---|
| Duration | |
| المستوى | |
| التحديثات | |
| القطاع | |
| الصيغة |

Reviews
Clear filtersThere are no reviews yet.