This option is available where your site has the Accounting Module. These screens allow you to store rules to automatically create Job Only Profit Journals according to the stored rules. This screen is found in Administration > Company Details Menu > Auto Journal Maintenance
Reassign Accounts Maintenance
This option is helpful in AU. This screen is found in Administration > Company Details Menu > Auto Journal Maintenance > Reassign Accounts Maintenance.
AU Customs Fees are received into Expedient on Account Number 2305 (ACS Processing Fees) but may be billed to your client on Account Number 2300 (Duty GST and Customs Fees)
Expedient can find all negative values for the Account Number in the screen matching positive values for the Reassignment Account Number and create Journals as part of the automatic overnight process to reassign the values to the new Account Number. The Journals will be automatically posted as part of the overnight process with the user ‘AUTO DUTY’.
E.g.
Account Code 2305 is to be reassigned to Account Code 2300 according to the above screen shot. The overnight process finds a Job with Account Code 2305 of value -$95. The Job also has Account Code 2300 with value $95. This means the Job has a cost of $95 against Account Number 2300 (Duty GST and Customs Fee) and billed $95 against Account Number 2305 (ACS Processing Fees).
A Journal is automatically created to debit Account Number 2305 with $95 and a Journal is automatically created to credit Account Number 2300 with -$95. The Account Number 2300 is now balanced and shows no costs and no profit, and the Account Number 2305 is balanced with $95 Costs and $95 Billed out.
Job Only Auto Journals Maintenance
This screen allows you to add and maintain rules to automatically create Job Only Profit Journals from WIP. This screen is found in Administration > Company Details Menu > Auto Journal Maintenance > Job Only Auto Journals Maintenance.
The automatic Job Only Profit Journals are created and posted every night.
|
|
Description |
Validation |
Default |
|
|
Account Number |
This is the Account Number to be automatically journaled |
Optional |
Blank |
|
|
Import/Export |
Select if the rule applies to Import or Export Jobs, or Both |
Mandatory |
Both |
|
|
Air/Sea |
Select if the rule applies to Air or Sea Cargo Jobs, or Both |
Mandatory |
Both |
|
|
Job Class |
Select a specific Job Class or ALL if the rule only applies to Jobs on a Consol. If the rule applies to all Jobs regardless of Consol select ‘Not Applicable’. |
Mandatory |
Not Applicable |
|
|
Active? |
Select if the rule should be included in the overnight generation of the journal |
Mandatory |
Yes |
|
|
Department |
Select if the rule applies only to a specific Department. Leave blank to apply the rule to all Departments |
Optional |
Blank |
|
|
Start% |
The rule can be applied to profits that fall within a specified % Profit range. Expedient will calculate the % value for the profit amount against the total sum of the Account Code billed for the Job. E.g. a Job has account 2700 that must be within %10 and %50 profit range to be auto profit journaled. The account code 2700 total value in credit for the job number in the journal is $20. The total value of account code 2700 billed for the job across multiple invoices was $200. Therefore the % profit is 10% and falls within the range and can be auto profit journaled. Enter the start of the % Profit range |
Mandatory if an End % entered |
Blank |
|
|
End% |
Enter the end of the % Profit range |
Mandatory if Start % entered |
Blank |
|
The Journals are posted overnight as user ‘AUTO JNL’