This program is to create journals that will run based on a regularly scheduled batch job and are used to divide costs evenly over a certain period.
E.g. A car insurance is always paid a year in advance, but in the P&L you wish to see the cost per month.
When the invoice is booked, the account is usually an account like "Prepaid Insurance". Then monthly 1/12 of the amount will be re-allocated from prepaid to expense "Car Insurance".
In this program this exercise can be automated, making month closing faster and less work.
Filters
Completed: Tick this box if you want to see the completed transaction.
Not Complete: This is pre-selected by default.
Automatic Journal: This is pre-selected by default, Untick if you don't want to see the transaction(s) created in this program.
Fixed Asset: This is pre-selected by default, Transactions created from the fixed Assets progam are in green color.
Hide Inactive: Untick if you want to show the inactive transaction.
HOW TO USE AN AUTOMATIC JOURNAL?
- Click the "add new record".
- Give the Journal a recognizable name.
- Select the account to be credited.
- Select the start date of the journal. Select any date except 29, 30 & 31 as other months won't have this date. This will be the date of the journal.
- Select the Division and Department.
- Select the account to be debited.
- Total No. of months: Enter the number of months, in this example, I entered 24 as the insurance is good for 1 year.
- No. of months booked: Enter the number of months if you have partially booked the journal. If not, enter a "zero" value.
- Remaining No. of months: This field will automatically adjust based on the value entered on the no. of months booked.
- Amount Invoice: Enter the invoice amount excluding VAT/Tax.
- Amount booked: Enter the amounts booked if you have partially booked the journal. If not, enter a "zero" value.
- Balance: This is an auto-calculation.
- Journal Amount: This is, the balance divided by the number of months.
To Edit
- Click the "edit" icon and start editing the data.
- Click "submit" when done.
- Click "Cancel" if you don't want to make any changes.
Remarks: The system will allow the user to edit but whatever is already posted will not be affected. You'll need to make a manual correction for the previous transactions.
To Delete (deactivate)
- Select the data that you want to deactivate, click the "deactivate" button.
- Are you sure you want to de-activate this record?
- Click "OK".
To Re-activate
- UN-tick the box “hide inactive” to show the inactive records.
- Select the data that you want to re-activate, and click the "re-activate" button.
- Are you sure you want to re-activate this record?
- Click "OK".
Example of the automatic journal entry. This is an automatic entry.