Expedient User Manual – General Ledger
Contents
1. 18 ODO 18 Prones VP NOE 19 WIP Pront amp 19 luf 23 RT 24 WIP gei MEN NE 25 WIP A COS EM ID UM ME 26 TS fel INT ATIS M TEE 27 WIP SSE SS MIU MIDI MIENNE IUE 29 NEP Mit 30 AMO OE 30 expedient GENERAL LEDGER INTRODUCTION General Function allows users to take up profits losses against shipments jobs or directly to the General F Xpedient software contains an Accounting Module one of which is the General Ledger function The Ledger It also allows users to amend any errors that have taken place when assigning costs to jobs Reporting functions also exist in this module After you have logged in click on the General Ledger Folder Doing this will display the following Functions HE WE WE WE E WE ME io ul ul c Chart of Accounts Job Journal Job Only Auto Profit Recurring Journals Journal Entries Transaction References G Ledger Period Totals View Profit amp Loss Check for all Postings Start New Period Post Journal Entries Post Job Journals Post Job2. Add Update Delete Find Browse Previous Next General Journal Entries Date Of Journal 21 03 2010 4 Journal description FIX UP GL Code Dept Account Description Amount 6500 000 EXPENSES SUBJECT TO FBT 6600 000 GOODWILL AMORTIZATION Entered By gavinm On 21 03 2010 Balance Field Name Description Validation Default Date of This is the date in which you are creating the general journal Mandatory Today s Date Journal Journal This is a short description of what is being performed Optional Blank Description G L Code Enter the job no in which you wish to journal Mandatory Null 15 Account No This is the Charge Code in which you wish to journal for the Mandatory job Department This is the department of the job This is a display only field N A Data pulled from Job Client This is the Client for which the job was performed Data pulled from Job Description This is the description of the Charge Code that you wish to N A Data pulled journal from Account No Amount This is the amount in which you wish to journal To take the N A money off the charge code then enter a negative amount To put money on the charge code then enter a positive amount Balance This is the balance between the negative and positive N A amounts this needs to be O in order to save the Job Journal Posting General Journal The next step is to Post the General Journal Transaction References This function is used f
3. ELG 254530 4006 aren howsae 5 45370 hoes 5046008 toes 14003 3945778 5045555 5045322 245096 5045360 049375 EES EES EES EES EES EES EES EES Ges aes Ges 1000912015 1900512016 190061206 voros 10021206 Worm SINNOH i205 059 205 70205 10127204 2407 2018 2500602005 E 09642018 2300222015 4 260772015 eon QS 7406 2005 0700602015 290742008 2606 2005 200272915 2 20 Led seo Cleon Nro WRI 1200206 Rano VSCAHYG v8SCAnYG VSCAMYG VSCAHYG VSCAHYVG VSCAMYG VSCAHYG DEMCON NCASSAL DEMCON AARTSTO AARTSTO NNUPCONNM DEMCON DEMCON DRECT DEMCON ASLESHI NCASSAL DEMCON DEMCON DEMCON NCASSAL HELON HELOM6 NCASSAL DEMCON 894 CACSWOR VJS WPAR AALESHI ASLESHI AARTSTO AARTSTO AC AARTSTO 100712015 075 204 93920 09042075 24772015 0970312075 2900206 161207 08402015 09062015 240712015 24072015 07 08 2015 orients 190012015 WH 2510204 vono 20121204 noon 01021206 101021208 AACTSTA NCHINAY PHAMSUD PETA LANGTON HELEN STAPELY GMA SUPPORT GMA SUPPORT PETA LANGTON PETA LANGTON PETA LANGTON GMA SUPPORT PETA LANGTON PETA LANGTON PETA LANGTON PETA LANGTON PET
4. 086 16953544 2314 WAR RISK SURCHARGE 5014803 02 0271 1308 14 570007 2310 FREIGHT 501480 0212715 1206 15 57020407 2311 5014823 6202715 1305 15 5703207 2316 EXPORT SECURITY FEE 1014003 02021 Yo 7007 232 CARRER SURCHARGES 5014803 5 4 i 620215 1905 18 5203507 2225 TERMINAL HANDLING CHARGE 1014003 T aans 110614 37007 2330 AUSTRALIAN PORT CHARGES 5014803 62025 135 15 5709507 2700 CARTAGE 5014803 T 020215 1 0415 570207 2702 CARTAGE FUEL SURCHARGE 01480 6292 5 5703607 2745 FCL TME SLOT BOOKING FEE 5014548 Si 180575 232 12324235 2310 FREIGHT 01404 270 12 48582853 ZMS AR CARGO REPORTING CNOTT 173897 RAGED 5014854 270515 12338558853 2489 NAYBLL PROCESSING FEE 173897 RABED 504017 501481 hus 29 RR 25 WIP Consol Balances The Consol Balances Report shows the financial information for each Consol No and is sorted by the Department Code It also includes Consol WIP and Account Notes Please see below screenshot for the PDF Version Expedient Consol No DEPT NIA 2727117 Agent OEUNSHI 30 10 14 TESTING TEST 17 09 13 WIP Balances by Consol No Date Reg ETADisch Dest Master Bill 12 03 15 081 08110104 16 09 13 Please see below screenshot for the XLS Version EXpedient Devtest Logistics Pty Ltd ABN 20079873625 2B Buckley Sron ees suber VIC 3040 Prt 613 3331
5. 93313900 FAX 61 3 93313075 ww w qmaaust com au WIP Statistics Detailed Printed by PETA LANGTON 31 08 2015 10 38 20 30 Days Time Date 31 08 2015 150 Days 867075 73 867075 73 TOTAL JOBS By Dept SEA SES SIA 5 Sub Total PAID OUT amp NOT BILLED WIP Debit SEA 102 21 SES 195767 29 SIA 3635 84 SIS 106046 99 Sub Total 305552 33 BILLED amp NOT PAID OUT WIP Credit SEA 790 70 SES 133706 83 SIA 6113 77 SIS 93799 80 Sub Total 234411 10 WIP TOTALS WIP Debit amp WIP Credit SEA 688 49 SES 62060 46 SIA 2477 93 SIS 12247 19 71141 23 29 102 21 195767 29 3422 14 105901 99 305193 63 790 70 133706 83 5128 47 93249 80 232875 80 688 49 62060 46 1706 33 12652 19 72317 83 WIP Profit Export The WIP Profit Export Report shows the Job Financial information for each Job No amp Consol that have not been balanced NOTE This report is the same as the WIP Profit Enquiry Screen Please see below screenshot for the XLS Version Devtest Logistics Pty Ltd ABN 20079873 26 291 Duckles Street toa suburb VIC 3040 Prt 61 393913909 FAX 619 91219075 EXpedient fv WIP Profit Export Report Prirted by PETA LANGTON 28 06 2015 14 23 06 Jobs vith Date ol Reg between 2800612014 and 28 08 2015 EES 2520002015 VSCAMTG 000 0 wW 5720969 iremen eae 0752 236755 26756 ers 236759
6. Only Journals Post Gen Ledger all Months Reports QB expedient Expedient Accounting Periods Accounting Periods are used to close off financial transactions to gain a picture of the overall financial status of the company at the end of any given period Accounting Periods are utilised in the following areas of the system e Bank Reconciliation e Profit Reporting End of Period Reports e User warning when entering invoices in a previous period Please Note Transactions can still however be back dated This can be stopped if the site chooses to do so See Administration Company Details Masterfile oldest Journal Date Enforce Start New Period Please Note At the end of a year once the new period is started the system automatically creates the new year See below screen A Start New Period Selections Start Date End Date Current Period 04 2011 01 10 2010 31 10 2010 New Period 05 2011 01 11 2010 30 11 2010 Is this ok to Continue YES Process Only Begin a New Period Gathering Elements Stop Output to no output process only OVR End of Period Process Below is the recommended process for ending a period in Expedient 1 Check for All Postings a Postwhere applicable 2 PostGeneral Ledger All Months a If no transactions for new period have been posted and not using the Batch Print Statement Process then i Print Statements ii Start New Period b If t
7. 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 12 e EXpedient software Job Only Auto Journals Maintenance This screen allows you to add and maintain rules to automatically create Job Only Profit Journals from WIP The automatic Job Only Profit Journals are created and posted every night 9 Job Only Auto Journals Maintenance EXPEDIENT DEVELOPMENT File View Options GMA Maint Help 34 J gt Add Update Delete Find Browse Previous Auto Journal Rules Auto Journal Criteria Enter the rules to apply when automatically journaling profit accounts Account Number 2430 DELIVERY ORDER FEE Import Export Import Air Sea Sea Job Class FCL This rule requires the Job is on a Consol Active Yes Auto Journal Range Set the Profit Range to restrict the automatic journaling within Department Start End 96 Additional Information Modified By New Document Field Name Description Validation Default Account This is the Account Number to be automatically journaled Optional Blank Number 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 Mandatory Not on a Consol If the rule applies to all Jobs r
8. cost code to another on the same job e Bulk Profit Uptake for o o Department s o Account Number s Job Journals are used when users which to move money from one 1 charge By clicking the Add button or typing A will place the cursor in the input screen Add Mode See below Field Name Description Validation Default Header Document This is the date in which you are creating the job journal Mandatory X Today s Date Date Description This is a short description of what is being performed Optional Blank Source This is the action being performed this is a no entry field and N A JP is set to Job Journal Adjustments Enter the job no in which you wish to journal Mandatory Null Account No This is the Charge Code in which you wish to journal for the Mandatory job Department This is the department of the job This is a display only field N A Data pulled from Job Client This is the Client for which the job was performed Data pulled from Job Description This is the description of the Charge Code that you wish to N A Data pulled journal from Account NO Amount This is the amount in which you wish to journal To take the N A money off the charge code then enter a negative amount To put money on the charge code then enter a positive amount Balance This is the balance between the negative and positive N A amounts this needs to be O in order to save the Job Journal Set Bulk Criteria This function allows users to take up b
9. 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 TA Reassign Accounts Maintenance EXPEDIENT DEVELOPMENT cB x w Add Update Delete Find Browse Previous Next Selection Criteria Reassign Account Numbers Account Number Account Reassign to Account Modified By Modified On Description Account Number Description 2305 ACS PROCESSING FEES 2300 gt gt gt gt DUTY GST AND CUSTOMS FEES HELEN STAPELY 12 05 2015 1 of 1 OVR M A 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 F 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 595 The Job also has Account Code 2300 with value 595 This means the Job has a cost of S95 against Account Number 2300 Duty GST and Customs Fee and billed S95 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 S95
10. 0 28 03 2010 Job Financial Status All Only with WIP Balance WIP Import Criteria Department Client Code Load Port Sales Person Search Results 7 Consol No Date of Reg Client Paid Out Journal Actual Profit WIP Profit EST Profit Profit 1 2712843 2016324 02 03 2010 17 03 2010 382 09 2 2712978 2016252 NIS 26 02 2010 NMULMED 04 03 2010 843 58 843 58 R 843 58 843 58 3 2712978 2016253 NIS 26 02 2010 NQUACON 04 03 2010 1192 90 1192 90 t 1192 90 1192 90 4 2712978 2016254 NIS 26 02 2010 VGLOFOR 04 03 2010 2022 90 T 2022 90 2022 90 2031 35 5 2712979 2016242 5 26 02 2010 QROHAUS 27 03 2010 105 00 105 00 105 00 105 00 6 2712979 2016243 NIS 26 02 2010 NPALMIL 27 03 2010 572 90 T 572 90 572 90 572 90 7 2712979 2016244 5 26 02 2010 NBORFOR 28 03 2010 912 90 912 90 912 90 912 90 8 2712979 2016245 NIS 26 02 2010 NJASFOR 28 03 2010 144 05 144 05 144 05 144 05 Job Financial Acct No Acct Code Description i Journal Total Costs Billed 2325 TH TERMINAL HANDLING CHARGE 0 00 0 00 0 00 25 00 2330 AP AUSTRALIAN PORT CHARGES 0 00 0 00 0 00 105 00 2340 SC SEA CARGO REPORTING FEES 0 00 0 00 0 00 20 00 2341 CMR CMR COMPLIANCE FEE 0 00 0 00 0 00 20 00 2386 TSF TERMINAL SECURITY FEE 0 00 0 00 0 00 15 00 2402 HF HANDLING FEE 0 00 0 00 0 00 60 00 2411 IPF IMPORT PROCESSING FEE 0 00 0 00 0 00 20 00 2430 DO DELIVERY ORDER FEE 0 00 0 00 0 00 50 00 2 Hide Criteria gt New Search Refresh 4 Job Financial 2 Job On
11. 0 20240 DEPT NEA 2947755 6796054 2700 CARTAGE 490 275 QUARANTIME ASSESMENT FTE Job Totat 30 00 20 00 1400 4400 11 00 Department Total wo 20 00 140 1140 DEPT NIA 20963754 AARTSTO 1059015 070097215 30 DEUVERY ORDER 7709 CARTAGE 275 QUARANTINE ASSESMENT FTE Job Total 0 00 30 00 10 00 10 00 40 00 7310 FaNGHT 24 WIP Job Balances The Job Balances Report shows the Job Financial information for each Job No and is sorted by the Department Code This also includes Job WIP and Account Notes Please see below screenshot for the PDF Version WIP Balances by Job No Time 14 20 11 Date 28 08 2015 Grouped by Department Job Cust Code Consol No Date Reg ETADisch Dest Finalized Forwarder Master Bill O S Agent Billed PaidOut Journals DEPT EES 286754 VSCAHYG 5014818 DEMCON CHINA VAT Department Total DEPT NEA 2063755 DEMCON 081 08110104 Acct Notes CNOTE CARTAGE QUARANTINE ASSESMENT FEE Department Total DEPT NIA 2063754 AARTSTO 07 05 15 VPOTMEL MBT ST122331233 Acct Notes CNOTE 2430 DELIVERY ORDER FEE 2700 CARTAGE 2751 QUARANTINE ASSESMENT FEE 2063757 VSCAHYG VPOTMEL MAS TERBILL 2310 FREIGHT Page 1 of 14 Please see below screenshot for the XLS Version Devtest Logistics Pty Ltd ABN 20 079 273 626 201 Sucky Street res seburb VIC 2040 i Po 6t 2 83313900 p ien FAX 81 393313075 fiware www com WIP Balances by Job No Pri
12. 0 22 Entered By scottc Entered On 15 09 2015 Balance 1122 01 Cancel Insert Append Delete Enter Amount Enter new document into form OVR 7 Field Name Description Validation Default Document This is the date of the Job Only Auto Profit Mandatory Today s Date Date Description This is the description of what is being performed Optional Auto Profit Journal Source This is the action being performed this is a no entry field and N A JP is set to Job Journal Adjustments Job Consol This is the job or consol number in which users wish to take Mandatory X Blank No profit up on If users enter a valid consol then the screen displays all jobs against that consol where the jobs are still in progress F3Please Note if this job consol number is already balanced a system message will appear telling you so e SYSTEM MESSAGI e Current Job is balanced Please check again 10 Field Name GL Code Department Account Description Previous Bill Previous Journal Previous Cost Description This is the General Ledger code you wish to debit credit Clicking on the will bring up a lookup from the Chart of Accounts master file which is found in General Ledger Menu and is split be Balance Sheet Income and Expense Items This is the Department in which the payment is to be attributed This is the description of the General Ledger Code This is the amount that has already been billed Th
13. 00 000 on 00 000 om 00 000 no nwo 000 000 0 00 000 000 000 000 000 22239 000 00 000 000 000 000 000 000 000 000 om 000 000 00 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 30 40 00 0 00 000 000 0 00 000 1500 000 090 0 00 0 00 000 0 00 0 00 LE 0 00 0 00 000 0 00 090 0 00 0 00 0900 000 642 000 000 0 00 090 000 0 00 000 000 0 00 000 000 0 00 000 000 0 00 000 woe nos oo 20s 208 608 0 009 0 0 222 83 000 0 208 000 009 208 oo 909 4 20 32125 009 20 oo 0 09 000 0 0 09 20 09 0 09 000 09 009 0 00 09 20s 08 09 009 208 09 30 09 nw 0 0 000 000 om 000 om 22289 000 om 000 000 5531 000 00 00 26 00 22425 000 000 om 000 667 om 000 aw om 000 om 000 00 om 000 000 000 000 000 om 020 060 020 020 020 090 020 neo 020 0460 020 t 000 000 50 060 040 020 060 020 060 040 0460 060 020 020 060 020 060 1000 TESTING NOTES gt gt gt gt gt gt gt gt gt gt gt gt p gt gt gt gt gt gt gt gt gt gt gt gt gt
14. 236 58 7992 15 58 10 7534 31 106949 18 20 7913 39 207913 39 2613795 24 2619380 24 Sub Total 30440803 27 EU 3042408 54 BILLED amp NOT PAID OUT WIP Credit 00 406 55 406 53 3005 52 3074 52 1296929 19 1255323 18 174069 r5 1r3 4 45 26646 42 2 4 42 2174296 7 04 74172 04 Sub Total 4203503 50 D 30 0 831 3 4201552 20 WIP TOTALS WIP Debit amp WIP Credit 00 406 55 406 53 B46 7 37 5994 57 45 7691 50 45 7646 50 66534 54 66125 27 291266 93 251256 33 122581 80 122346 80 28 WIP Statistics Detailed This Statistics Report provides a detailed outline of Jobs for WIP Debits that have been Paid Out amp Not Billed or WIP Credits that have been Billed amp Not Paid Out It is filtered by Branch and Department Please see below screenshot for the PDF Version ey Expedient Total Outstanding Current to 30 Days Branch Devtest Logistics Pty Ltd TOTAL JOBS By Dept EES Sub Total 600 PAID OUT amp NOT BILLED WIP Debit EES Sub Total 29410 76 29410 76 BILLED amp NOT PAID OUT WIP Credit EES Sub Total 896476 49 896476 49 WIP TOTALS WIP Debit amp WIP Credit EES Total Please see below screenshot for the XLS Version 867065 73 867065 73 EXpedient software WIP Statistics Detailed Grouped by Department Devtest Logistics Pty Ltd A B N 20 079 873 626 281 Buckley Street res suburb VIC 3040 PH 61 3
15. 4205 2620622015 07041209 074012015 1900202015 1270312015 004206 osnon 020422015 0240422015 RADIS 028042016 00442015 0040402015 02042016 02042015 AARTSTO VSCAHYG vSCAHYG VSCAH YG VSCAHYG v8Canya VSCAHYG VSCAHYG AALESHI AARTSTO NKASAUS AADREUR VSCAHYG VSCAHYG AAL amp SHI or DEMCON or VSCAMYG DEMCON NPRICAR AARMSOL vSCAHYG SOPLVYN DEMCON AAERINT DEMCON AACTSTA DEMCDON AARTSTO SOPLWYN SOPLYYN SOPLWYN SOPLWYN SOPLYVYN SOFLVYN SOPLYVYN SOFLVYN SOPLYYN 970201 9702706 220082013 oman Hno meis 2909208 90000206 1370312003 2900812014 200702014 907042055 910721206 240208 290812012 220020 0500212015 2900412015 20222005 Ouo VONIS 970205 ONIS 9070205 auon ouo ron anono OOC AUSTRALIA PA ANL CONTAINER LINE TEST TEST2 TESTS GMA SUPPORT GMA SUPPORT PETALANGTON PETALANGTON TEST TEST2 TESTS PETALANGTON PETALANGTON PETALANGTON 000 10 00 000 0 00 0 00 000 000 0 00 06 600 178173 000 0 00 900 0 00 000 0 00 000 000 0 00 000 000 0 00 0 00 000 0 00 0 00 000 000 0 00 0 00 0 00 000 000 0 00 000 000 0 00 000 30 00 000 no 00 000 om no 000 00 EO om om 000 om ssy 000 000 om 259 000 3 000 000 om 000 66 om 000 000 00 00 000 om
16. 9500 FAX 61397710075 Qm bus ay WIP Balances by Consol No Printed By PETA LANGTON 28 08 2015 14 22 22 Consol wth Date of Reg between 23 10 2013 an 26 00 2015 6706554 NEA ga SES ss us ses SES SES SES SES s SA E E E E E SA SA SA E E OELUNSH Iwo 100375 081 0810 1203 15 081 06 110104 061 U545631 909713 7 H OG BUGS 745 972681 10813 745 11902881 Hans 765302561 005 6963544 5703607 STOOT 5709607 5703607 5703507 Grouped by Department Acct Code Acct Description CARTAGE QUARANTINE ASSESMENT FEE Consol Total Department Total INTERNATIONAL TERMINAL FEE Consol Total DUTY GST AND CUSTOMS FEES FREIGHT CUSTOMS DUTY REFUND AIRWAYBILL FEES Page 1 of 11 Acct Code Acct Description AcctNotes 2700 CARTAGE 2751 QUARANTINE ASSESMENT FEE 2500 INTERNATIONAL TERMINAL FEE 2300 DUTY GST AND CUSTOMS FEES 2310 FREGHT 2651 CUSTOMS DUTY REFUND 2660 ARWAYERL FEES 23 WARRISK SURCHARGE 2310 FFBGHT 231 CAF DAF 2316 EXPORT SECURITY FEE 2523 CARRIER SURCHARGES 2325 TERMINAL HANDUNG CHARGE 2330 AUSTRALIAN PORT CHARGES 2700 CARTAGE 2702 CARTAGE FUEL SUFICHARGE 2745 FEL TIVE SLOT BOOMING FEE 2310 FROGHT 2345 AIR CARGO REPORTING FEES 2489 WAVELL PROCESSING FEE 2500 INTERNATIONAL TERMINAL FEE 2505 ALINE
17. A LANGTON GMA SUPPORT ature TESTI TEST2 TESTI TESTI TEST2 TEST 0 e e neo o heo boo he he 0 he oo aneo neo neo hoo neo KEI deo oo w deo boo neo hoo boo boo eoo boo 0 00 00 hoo boo 50 00 50 boo hoo 0 00 boo 00 boo boo boo boo boo hoo hoo boo boo boo boo to n to o to om to o to o to om o on om o on 2m to 2m 4020 on o 200 hoo o El im boo 20900 im KEJ peo KEJ 280 hoo 39800 heo neo 0 heo 50 00 EE aso o0 0 heo o0 eo heo raso 0 heo KEJ KEI o deo heo o0 00 heo beo heo 0 boo boo 1000 boo boo 1200 boo 250 00 boo boo 00 ioo boo boo boo boo o o o o o w o o o o o o So o hoo 765040 o o o no 2450 2052 o io o e422 o DOMESTIC AR WIP Pro
18. ES includes the Job Total amp Department Total If NO it does not include the Job Total amp Department Totals It only includes a Totals at the end of the Report This applies against the PDF and XLS Versions of the WIP Job Report If CSV is selected then it defaults the Include Totals field to YES and cannot be changed Therefore the CSV Version will always include the Job Total amp Department Totals Please see below screenshot for the PDF Version Expedient Job No Cust Code Consol No Date Reg 5014818 DEMCON DEPT NEA 2063755 DEMCON DEPT NIA 2063754 AARTSTO wip_job Please see below screenshot for the XLS Version Devtest Logistics Pty Ltd 2007868736 AB 873 626 Expedient WIP Report by Job No Printed by PETA LANGTON 28082015 14 13 37 HA Street Joss wif Date Reg between 237100013 and 28 08 2015 13 05 2015 13 03 2015 11 05 2015 11 05 2015 WIP Report by Job No Grouped by Department ETA Disch Dest Date Final WIP Notes Billed Paid Out Journals 12 03 2015 2700 2751 07 05 2015 FREIGHT CHINA VAT 11 05 2015 CARTAGE QUARANTINE ASSESMENT FEE Job Total Department Total Page 1 of 19 Time 14 15 46 Date 28 08 2015 Profit Balance DEPT EES 286754 VSCAMYG 12052015 2310 FREGHT 1 Job Totat 0 00 10 40 0 00 1040 5114018 CEMCON 12022015 2722 VAT on Job 0 00 262 00 0 40 388 00 262 00 Department Total 00 270240 9 0
19. HANDLINGFEE 2650 AMFWAYERL FEES 2500 INTERNATIONAL TERMINAL FEE 2300 DUTY GST AND CUSTOMS FEES 2340 SEA CARGOREPORTING FEES 2345 AR CARGO FEPORTINGFEES 2346 AQISEXDOCS 205 CRANE 2460 GOVERNMENT ANALYST FEES 26 Department Total Time 14 22 33 Date 28 08 2015 Billed Paid Out Journals 500 no 100 6 00 TESTING WIP Statistics Summary This Statistics Report provides a summary of Jobs for WIP Debits that have been Paid Out amp Not Billed or WIP Credits that have been Billed amp Not Paid Out It is filtered by Department Please see below screenshot for the PDF Version WIP Statistics Summary Grouped by Department Current to 30 Days 30 Days 60 Days 90 Days 120 Days 150 Days Sub Total BILLED amp NOT PAID OUT WIP Credit 406 59 3085 52 1258823 18 173074 45 00 ER 5 1 Grouped by Department Total Outstanding Current to 30 Days 30 Days 60 Days 90 Days 120 Days 150 Days WIP TOTALS WIP Debit amp WIP Credit 55 27 Please see below screenshot for the XLS Version Devtest Logistics Pty Ltd 20 073 873 626 201 Buckley Street res suburb VIC 3040 EXpedient sorrware wwWw qmaaust cam au WIP Statistics Summary Printed by PETA LANGTON 31 08 2015 10 36 56 TOTAL JOBS By Dept 00 Sub Total PAID OUT amp NOT BILLED WIP Debit 00 0 00 0 00 3553 03 5963 09 T33
20. NIA VSCAHYG 2063757 HOUSEBILL1305A 13 05 2015 0 00 2310 FREIGHT NIA VSCAHYG 2063762 HOUSEBILL1306C 15 05 2015 0 00 2310 FREIGHT NIA DEMCON 5014817 13 03 2015 0 00 2310 FREIGHT SES AALBSHI 5014803 5703607 02 02 2015 22 09 2310 FREIGHT SIA DEMCON 5014849 HOUSE001 18 05 2015 10 00 2310 FREIGHT SIS DEMCON 3046042 TST123 12 06 2015 9 00 2310 FREIGHT SIS AACTSTA 5014804 ATLMELE01035 02 02 2015 5 52 2310 FREIGHT 515 DEMCON 5014846 TST 9900 15 05 2015 0 00 2310 FREIGHT DEMCON 5014856 28 05 2015 50 00 2310 FREIGHT DEMCON 5014868 HOUSET111 23 06 2015 8 00 2310 FREIGHT VSCAHYG 3046013 13 05 2015 0 00 2310 FREIGHT ABELENT 3045560 22 05 2014 4 00 2310 FREIGHT CONPOW 3045687 MASTER 03 09 2014 10 00 2310 FREIGHT NCASSAL 3045809 6706840 28 11 2014 0 00 2310 FREIGHT 1 VSCAHYG 3045756 HELTESTO2A 20 10 2014 76 23 2310 FREIGHT VSCAHYG 3046046 68510810021B 23 06 2015 10 00 2310 FREIGHT VGRELUX 3045274 SZNMEL139443 01 10 2014 34 45 2310 FREIGHT AALIVIE 3045488 13 12 2013 0 00 2310 FREIGHT AALBSHI 3045681 TEST BILL 1 03 09 2014 0 00 2310 FREIGHT VSCAHYG 3046061 HOUSEB1007 10 07 2015 0 00 2310 FREIGHT AALBSHI 6010630 13 03 2015 10 00 2311 CAF BAF AALBSHI 5014803 5703607 02 02 2015 55 22 2311 CAF BAF DEMCON 3046042 TST123 12 06 2015 18 00 23 WIP Job The Job Report shows the Job Financial information for each Job No and is sorted by the Department Code This also includes Job WIP Notes Report Parameter Include Totals Defaults to NO If Y
21. NT DEVELOPMENT File View Maint Help X E 4 D Add Update Delete Find Browse Previous Input Recurring Journal Jnl Ref No Description Recurring Group AcctNo Dept Description Amount No Documents Selected Field Name Description Validation Default Jnl Ref No The number you assign to this Recurring Journal This is Mandatory Blank visible in the lookup screen within the General Journal Entry Screen Description The short description you assign to this Recurring Journal Mandatory Blank This is visible in the lookup screen within the General Journal Entry Screen Recurring N A N A N A Group E d Ecl Acct No This is the Acct No Code that will be used as the Standard Mandatory Null Recurring Journal 14 Field Name Description Validation Default This is the Department in which the Journal will be assigned Mandatory X Null to Amount This is the amount of money in which the Recurring Journal Mandatory Null Will be assigned Journal Entries This function gives the user the ability to create a Journal Entry that is not Job related l e Depreciation of Assets You can also use this screen to perform a fix to a Journal Entry that was entered in Error This is performed by entering a positive amount on one line and a negative amount on the subsequent line See below General Journal Entries EXPEDIENT DEVELOPMENT Ww File View GMA Maint Help amp
22. Number 1060 Type CURRENT ASSETS Description ANZ EURO ACCOUNT Department Period Month Period Period Amt YTD Balance Postings 09 2010 2363 10 09 2010 2416 05 08 2010 2416 05 08 2010 2363 10 07 2010 2416 05 07 2010 2363 10 06 2010 2416 05 06 2010 2363 10 05 2010 2363 10 05 2010 2416 05 04 2010 2363 10 04 2010 2416 05 03 2010 2363 10 03 2010 2416 05 02 2010 2363 10 6 of 711 Options In the Options Menu there is a View Summary screen This screen summarises the transactions that have occurred during the selected period See below Select Period Year Period amp Year 9 2009 MARCH 2009 Department 000 Q Balance Forwd 857691 29 2981960 21 3442875 21 Balance 396776 29 18 Work In Progress WIP The WIP Menu is used to view financial information against each Job To know when to take up the Profit and which Jobs still need to be finalised WIP Profit Enquiry Import amp Export This screen allows the user to take up the profit and view the Job Financials for each Import and Export Job NOTE This screen has the same conditions as the WIP Profit Import amp Export Reports Therefore you don t need to run these reports to view the Jobs that you need to Balance Profit Enquiry Import amp Export WIP Profit Enquiry Search Criteria Search WIP Profit Import Filter By Date of Reg Between 26 02 201
23. Sales Person This is the Person responsible for the sale on the Job Job Financial Group Acct No GL General Ledger Account Number that is associated with the Job Acct Code Account Code that is associated with the Job Description Account Code Description that is associated with the Account Code Paid This figure is the amount on the Creditor Invoice that has been raised against the Job Journal This shows any Journal Entries that have been created and posted against the Job Total Costs Calculation Paid Column Journal Column Billed This figure represents the amount that has been invoiced against the Job in the Debtors Invoice screen Balance Calculation Totals Costs Column Billed Column Action Buttons Hide Criteria Hides the Search Criteria Group amp Import Export Criteria Group and the Search Results group becomes larger showing more rows When this button is selected the button label changes to Show Criteria when the button is selected again these groups re appear New Search Clears the current search and shows the default Search Criteria Refresh Re runs the query that has been selected in the Search Criteria Job Financial Once a Job is selected this button directs the user to the Job Financial Screen 21 Field Name Description Default Job Only Auto Once a Job is selected this button directs the user to the Job Only Auto Profit Profit in ADD Mode with the Account Codes pre populated NOTE The abo
24. VIS 4X4 INCOME DO FEE 55 00 3004270 2430 VIS AUSSTAQ DELIVERY ORDER FEE 20 00 3004270 4430 VIS AUSSTAQ INCOME DO FEE 20 00 3004316 2430 VIS AALAUS DELIVERY ORDER FEE 20 00 3004316 4430 VIS AALAUS INCOME DO FEE 20 00 3004360 2430 VIS HOLLTD DELIVERY ORDER FEE 25 00 3004360 4430 VIS HOLLTD INCOME DO FEE 25 00 3005738 2430 VIS DEMCON DELIVERY ORDER FEE 10 00 Total Disbursements Liabilities 391 00 Entered By scottc Entered On 15 09 2015 Balance Cancel Insert Append Delete Enter Job No Enter new document into form OVRL Posting Job Journals QB expedient The next step is to Post the Job Journal This process posts job journal to the General Ledger This is performed in the General Ledger Menu under the Post Job Journals Function v General Ledger Ej E E Poo Chart of Accounts Job Journal Job Only Auto Profit Recurring Journals Journal Entries Transaction References G Ledger Period Totals View Profit amp Loss Check for all Postings Start New Period Post Journal Entries Post Job Only Journals Post Gen Ledger all Months Reports Job Only Auto Profit Job only Auto Profit is used to take up profit on jobs This draws information from the General Ledger on the Work In Progress Jobs i e jobs with a balance not equal to 0 on what has been billed and what the cost has been on selected jobs the result being profit Please Note if the Expected Cost feature is turned
25. Volume Expedient User Manual General Ledger GB expedient Gavin Millman amp Associates Pty Ltd 281 Buckley Street Essendon VIC 3040 Phone 03 9331 3944 Web www expedientsoftware com au Table of Contents EXDCOICME ACCOUNTING 3 NEATENTO ec vnc ose esa cena ec 3 End of Pernod Prote OTT 3 Post GSE a Sh E 4 Check Tor all POS 4 Chant o AECOLIDES 5 Creating viewing Dart 5 Maintain Sub Revenue CODES 6 7 m E E ERU 7 9 Joo piro uro 10 creating a JOR Ony Auto Pront NOUN OO 10 Posting Job Only Auto Profit Journal 12 Mann NANCE cee ct case en gatas rM 12 Re aS SIS Account 12 Job Only Auto Journals Maintenance 13 Recurring 14 JOU DO 15 POSUNE Ste eal 16 16 ECOG PC EE E
26. egardless of Consol Applicable select Not Applicable Active Select if the rule should be included in the overnight Mandatory Yes generation of the journal Department Select if the rule applies only to a specific Department Leave Optional Blank blank to apply the rule to all Departments Start The rule can be applied to profits that fall within a specified Mandatory if Blank Profit range Expedient will calculate the 96 value for the profit an End 96 amount against the total sum of the Account Code billed for entered 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 520 The total value of account code 2700 billed for the job across multiple invoices was 200 Therefore the profit is 1096 and falls within the range and can be auto profit journaled Enter the start of the 96 Profit range 13 Field Name Description Validation Default Enter the end of the 96 Profit range Mandatory if Blank Start entered The Journals are posted overnight as user AUTO JNL Recurring Journals Recurring Journals allow users to set up Journals that require on going allocation such as Monthly Depreciation Once a recurring journal has been set up then users can select this journal in the Journal Entries Screen for ongoing use EJ tow Standard Recurring Journals EXPEDIE
27. en WIP Profit Import is selected ETD Estimated Date of Departure Shown when WIP Profit Export is selected Billed This figure represents the amount that has been invoiced against the Job in the Debtors Invoice screen Paid Out This figure is the amount on the Creditor Invoice that has been raised against the Job Journal This shows any Journal Entries that have been created and posted against the Job WIP This figure shows what is still outstanding to be balanced against the Job Actual Profit This figure is the difference between what has been Billed and Paid Journal Applies to the 4000 series Charge Codes WIP Profit Calculation WIP Amount Actual Profit Amount EST Profit This figure is what has been billed excluding GST Profit Var WIP Profit column minus EST Profit column 20 Field Name Description Default Job Financial Job Financial Status of the Job This is based on specific calculation Status If Billed O amp Paid Out gt 0 Not Billed But Paid Out If Billed lt Paid Out Paid Out gt Billed If Paid Out 0 amp Billed gt 0 Billed but Not Paid Out If Billed gt Paid Profit If Billed 0 amp Paid Out 0 Not Billed Not Paid Out WIP Note This information is from the WIP Tab in the Job Note Job Type This column is only shown if WIP Profit Export is selected and if DOMESTIC is turned ON ShipCo This is the Shipping Company that is used to Ship the freight
28. fit Import The WIP Profit Import Report shows the Job Financial information for each Job No amp Consol that have not been balanced NOTE This report is the same as the WIP Profit Enquiry Screen Please see below screenshot for the XLS Version Devtest Logistics Pty Ltd ABN 20 079873 626 281 Street VIC 3040 61 393319500 FAX 613 80202075 EXpedient WIP Profit import Report Prirted by PETA LANGTON 2810672015 14 23 32 Jobs vith Oste of Reg between 2810612014 and 29 09 2015 _ 206 DateofReg ETA Company Sales Person Billed Paid Out Journais Actual Profit WIP Profit EST Profit Profit Variance star WIPMotes Job Ty 4705008 5703575 4708708 4705351 2063704 2063766 2003757 2063798 2063759 20370 2062060 2083782 3045683 346006 201025 24327 2063728 2063738 2436 2063706 2063787 3720980 37290025 musi 2063735 20375 4020852 5014820 402911 3045971 3945199 mues 5014822 9014022 504825 5014828 5014827 5304828 5014829 6014020 04821 5014822 5014022 MA MA MA MA MA MA MA MA MA MA MA MA MA MA MS 5 MS aa as as 1390502015 130061206 twou 1390502015 1061206 02429204 62 2 1 19061206 Menno ovine non 0071206 Worm 27037205 070042015 262082019 1201200 mow LOU nu 070
29. here have been transactions posted in the new period and a new period has already been started then i Prepare Debtors ii Print Statements Please Note Anytime users wish to print a Debtors Aged Trial Balance Creditors Aged Trial Balance or End of Period WIP at the end of any Period firstly Prepare each in the End of Period Reports Menu QB expedient Post General Ledger All Months This function is used for reporting purposes only This updates all of the data to be current and up to date for viewing of e Debtors Aged Trial Balance e Creditors Aged Trial Balance e General Ledger Aged Trial Balance e Profit and Loss e Balance Sheet e Bank reconciliation Check for all Postings This function gives the user a snapshot of any postings that have not been performed across the system Chart of Accounts This screen holds the Chart of Accounts Masterfile The Account Codes are numerical The structure and headings of accounts should assist in consistent posting of transactions Each nominal ledger account is unique to allow its ledger to be located The list is typically arranged in the order of the customary appearance of accounts in the financial statements profit and loss accounts followed by balance sheet accounts This allows users to add view general ledger codes Creating Viewing Chart of Accounts Once you have selected the Chart of Accounts you will be presented with the following screen By clicking the Add button or
30. his is the Type of account As per above based on the number Based on you enter will display the above types Display only Account Number appear on invoices balances sheets etc This defaults to the same as the description this is used to group Mandatory Blank the accounts when printing out Profit and Loss and Balance Sheets Field Name Description Validation Default Indicator is not a BAS Indicator FXC Indicator This indicates whether this General Ledger code can be used N A N a Account active will allow users to utilised this code A This is used to portion money to Foreign Currency Variation am Account Code This is used in the Foreign Contra Payment Acct Receipt Program No Mark Up This is used to remove the ability for users to alter the Expected Blank Allowed Cost when Billing During the billing process if the Charge Code only if Exp hasthis set to YES then the Expected Cost will default to the Local Cost turned Amount representing No Profit This is used for Charge Codes on where not profit is taken up like Duty and GST Revenue This refers to which revenue stream this is to be assigned to Mandatory Blank Group either Customs or Freight Forwarding This is only used for for Revenue Codes Revenue Codes only Sub Revenue Sub Revenue Group is for reporting purposes and allows you to Mandatory Blank Group group code within the revenue group For example you can for group Freight Fo
31. is is the amount that has already been journaled This is the cost that has already been loaded against the charge code Validation Default Mandatory Blank Null N A Defaults from Cost Code N A N A N A Total Journal N A Total Cost Amount This is the amount left over Previous Bill minus previous cost This is the profit loss amount 11 N A Previous bill minus Previous cost QB expedient Posting Job Only Auto Profit Journal The next step is to Post the Job Only Auto Profit This process posts the information to the General Ledger and takes the profit up Once this has been performed these jobs will no longer appear in the Work In Progress Report Please Note For the WIP Reports excluding the WIP Profit Reports Screen to coincide with the above immediately users will need to Prepare the WIP See below menu item Alternatively users can wait until the next day as the WIP is prepared overnight as well Profi t Job CostCode Profit Dept YTD By Country Controls Prepare WIP Prepare Turnover Control Totals Auto Journal Maintenance These screens allow you to store rules to automatically create Job Only Profit Journals according to the stored rules The menu option is available from Administration gt Company Details Menu Auto Journal Maintenance Reassign Accounts Maintenance Job Journals Maint Reassign Account Maintenance This option is helpful in AU AU Customs Fees are
32. ly Auto Profit 2 Output to CSV Records found 1557 Field Description Default Search Allows the user to search by WIP Profit Import and Export Profit Import Filter By Allows the user to search by the following Date of e Date of Reg Import amp Export Reg e Arrival Date Import e Departure Date Export NOTE Any ETD that is blank in the Export Job will not appear in the search results Date Range The Date Range cannot be greater than 3months It defaults to look back 2 months for 1 week Job Financial Allows the user to search by the following Status e Not Billed but Paid Out e Paid Out gt Billed Loss e Billed but Not Paid Out e Profit e Not Billed Not Paid Out NOTE The Not Billed but Paid Out amp Paid Out gt Billed Job Financial Status are highlighted in red Only with WIP Allows the user to search by WIPs only or ALL Balance 19 Field Name Description Default Import Export Criteria Group Optional Department This is the Department Code that is assigned to the Job Use the Zoom on Blank this field to match the Air or Sea Mode Import amp Export Client Code This is the Customer Code that is associated with the Job Use the Zoom on Blank this field to search the Customer Masterfile Import Only Load Port This is the Loading Port of the Shipment Use the Zoom on this field to Blank search the ISO Port Codes Import Only Sales Person This is the Person responsible f
33. nted PETA LANGTON 2808 2015 14 19 59 Jobs with Date of Reg between 23 10 2013 and 28 08 2015 Cust Code Date Reg tTADisch Dest Finalized Forwarder O SAgemt AcctCode Acct Description 206754 s VSCANYG 1308 15 2010 FREIGHT 9 50 48 8 8 DEMCON 13 03 15 2722 CHNA VAT 200 2067744 100515 129215 081 201 10194 2700 CARTAGE 172099 RAGED 1506 2063755 NEA DEMCON 11 05 35 120315 081 361 10104 275 ASSESMENT FEE 173899 RAISED 12 00 3063754 AARTSTO 110915 0734 15 511223 1233 2439 DELIVERY ORDER FEE 1701 RAGED 200 2083754 AARTBTO 1105 15 0795 15 MBT 8T1223341233 2700 CARTAGE 173821 RAISED 900 2083754 AAWTSTO 11 0515 070575 MBT ST 122351233 2751 QUARANTINE ASSESMENT FEE 173921 RASED 206757 120515 MAS TIRBLL 2310 FREIGHT 90 2083761 13 05 15 MAS TERBLL 2308 COASTAL 226 2063761 ost MAS TIRDAL 2395 TREAKBULK 090 150515 MAS TERBLL 2310 FREIGHT 22 2727117 14077715 041 12345 2500 NTERRATDNA TERMINAL Pet 6706787 13 03 15 745 14902661 2300 OUTY GST AND CUSTOMS FEES 0 6708787 130315 745 14022841 2310 FREIGHT 6706757 120215 745 14902061 2481 CUSTOMS DUTY REFUND 0 8708787 1303715 745 14022661 2850 ARWAYELL FEES 2206 4021809 110575 Mss 2430 DELIVERY ORDER rer 4001910 11 08 15 1105 15 2700 CARTAGE 40219 Mosis 2751 QUARANTINE ASSESMENT PEE 5014801 1902115
34. ode Total DEPT SIA ACCT CODE 2300 ACCT DESCRIPTION DUTY GST AND CUSTOMS FEES DEMCON 5014844 13 05 2015 Account Code Total DEPT VIS ACCT CODE 2300 ACCT DESCRIPTION DUTY GST AND CUSTOMS FEES VGRELUX 3045274 SZNMEL 139443 01 10 2014 AALIVIE 3045488 13 12 2013 Account Code Total DEPT NIA ACCT CODE 2309 ACCT DESCRIPTION COASTAL FREIGHT VSCAHYG 2063761 HOUSEBILL1306B 13 05 2015 Account Code Total DEPT EES ACCT CODE 2310 ACCT DESCRIPTION FREIGHT VSCAHYG 286754 13 05 2015 Account Code Total DEPT NIA ACCT CODE 2310 ACCT DESCRIPTION FREIGHT wip_cost_code Page 1 of 27 Please see below screenshot for the XLS Version Devtest Logistics Pty Ltd A B N 20 079 873 626 281 Buckley Street res suburb VIC 3040 EXpedient 2 2 software ww w gmaaust com au WIP Cost Code Printed by PETA LANGTON 28 08 2015 13 58 20 Jobs with Date of Reg between 23 10 2013 and 28 08 2015 CostCode Description Dept Code JobNo Bili Number Date Reg DateFinal Biltea Journals Balance NIA 2300 DUTY DEMCON 5014817 13 03 2015 0 00 0 10 0 10 FEES 2300 SIA DEMCON 5014344 13 05 2015 3 00 0 00 3 00 2300 A Soa CES vis VGRELUX 3045274 SZNMEL139443 01 10 2014 919 36 0 00 2300 sed vis AALIVIE 3045488 13 12 2013 0 00 2309 COASTAL FREIGHT NIA VSCAHYG 2063761 HOUSEBILL1306B 13 05 2015 0 00 2310 FREIGHT VSCAHYG 286754 13 05 2015 0 00 2310 FREIGHT
35. on at your site this function is performed at the time of posting the debtors invoice This action will only need to be performed when the Expected Cost entered does not match the actual cost and the job does not balance Creating a Job Only Auto Profit Journal By clicking the Add button or typing A will place the cursor in the input screen in Add Mode See below Job Only Auto Profit Journal Entries EXPEDIENT DEVELOPMENT File View Maint Help n Add Update Delete Find Browse Previous Next Consol Number system displays all Open jobs for that consol Allows for quicker profit take up Document Date 15 09 2015 Description AUTO PROFIT JOURNAL Source JP JOB JOURNA TS Job Consol No Job No Account No Department Description Previous Bill Previous Journal Previous Cost Total Journal Total Cost Amount 4900549 2330 QIS AUSTRALIAN PORT CHARGES 89 05 0 00 20 98 20 98 68 07 4900549 2700 QIS CARTAGE 90 00 0 00 0 00 0 00 90 00 4900549 2702 QIS CARTAGE FUEL SURCHARGE 9 90 0 00 0 00 0 00 9 90 4900550 2330 QIS AUSTRALIAN PORT CHARGES 212 55 0 00 50 08 50 08 162 47 4900551 2330 QIS AUSTRALIAN PORT CHARGES 246 35 0 00 58 04 58 04 188 31 4900555 2330 QIS AUSTRALIAN PORT CHARGES 112 45 0 00 26 49 26 49 85 96 4900557 2330 QIS AUSTRALIAN PORT CHARGES 87 75 0 00 20 67 20 67 67 08 4900607 2330 QIS AUSTRALIAN PORT CHARGES 588 96 0 00 138 74 138 74 45
36. or the sale on the Job Use the Zoom on this Blank field to search the User Masterfile Import amp Export Shipper The Party that requested the Shipment of Goods Export Only Blank House PPD This is the Party that is billed for the Shipment Prepaid Blank Use the Zoom on this field to search the Customer Masterfile Export Only House CCX That is the Party that is billed for the Shipment Collect Blank Use the Zoom on this field to search the Customer Masterfile Export Only Destin Code This is the Destination Port of the Shipment Use the Zoom on this field to Blank search the ISO Port Codes Export Only Search Results Group NOTE You can increase and decrease the size of this group by hovering over the bottom line that outlines the Search Results Group and dragging it up and down the screen H Line Number Consol No Unique Number automatically generated by Expedient upon creation of the Consol Job No This is the Job No attached to the Consol No This is an automatically generated Internal Reference Number Dept This is the Department Code that is assigned to the Job Date Of Reg This is the date the Job was registered in the System Client Shipper Client This is the Customer Code that is associated with the Job Shown when WIP Profit Import is selected Shipper The Party that requested the Shipment of Goods Shown when WIP Profit Export is selected ETA ETD ETA Estimated Date of Arrival Shown wh
37. or users to view any transaction that has occurred and the user that performed this function 49 Update Transaction Notation EXPEDIENT DEVELOPME S gt Add Update Delete Find Browse Previous Update Transaction Notation Orig Journal JP Doc No 3105840 Post No 8732 Post Date 29 06 2010 Wal Doc Date 21 03 2010 Ref Code JP Doc Desc ADI User gavinm 513513 of 513515 16 expedient Browse Button Any information that is displayed in the Browse window will be shown in Excel when the data is extracted Any modifications that are applied by the user in the Browse window remove or reposition column headings will be shown in the output to CSV Please see below screenshots for your reference Post Date Doc Date Orig Journal 09 01 2008 06 01 1988 LANCING DOCUMENT Reset to Defaults Reset Sort Order 1 of 1 Post Date Date Orig Ref Code Doc Desc Journal 09 01 2008 06 01 1988 AUTO YEAR END BALANCING DOCUMENT 1 E2 Output to CSV 1of 1 D E AUTO YEAR END BALANCING DOCUMENT 17 General Ledger Period Totals This function gives the user a snapshot of the general ledger codes by period and the movement for that period and the year to date balances G Ledger Period Totals GAVIN MILLMAN amp ASSOCIATES AUST PTY LTD ve ER 3 gt Add Update Delete Find Browse Previous Next G Ledger Period Totals Account
38. rwarding Revenue Groups into Sub Revenue Revenue group such as Agency Cartage Disbursements Codes only Maintain Sub Revenue Codes E This option allows the addition update and viewing of Sub Revenue Codes Use the Maintain sub Revenue Codes button in the toolbar H3Please Note Once you have added a code to the Chart of Accounts Screen users will need to add a corresponding Alpha Code in Administration Menu Alpha Charge Code Masterfile for those accounts that are to be used when invoicing This is used so users can use a short code when invoicing i e CA for Cartage See below Alpha Charge Code EXPEDIENT DEVELOPMENT x File View Options GMA Maint Help 2 4 P Add Update Delete Find Browse Previous Next Print Alpha Code List Alpha Codes Note For Charge Codes billing out or paying out ensure you add the related Chart of Accounts GL MENU FIRST Alpha Code i Account No 2310 8 FREIGHT Alternate Language Charge Description is GST Percentage 0 000 Landed Costing Landing Charges Mapping O seas Freight 1 of 1 OVR Job Journals Job Journals are performed when users need to e Transfer costs from one job to another o This occurs when users have assigned costs to a job in error and need to back it out and assign it to another job To successfully add Journals the total transaction needs to balance e Money from one
39. typing A will place the cursor in the input screen in Add Mode See below oll Chart of Accounts EXPEDIENT DEVELOPMENT File View GMA Maint Help 4 Add Update Delete Find Browse Previous Next Maintain Sub Revenue Codes Chart of Accounts Field Name Account Number Account Type Group Heading Account Number 2310 Account Type DISB LIABILITIES Revenue Group Freight Forwarding Sub Revenue Group Description FREIGHT Group Heading DISBURSEMENTS BAS Indicator Other FXC Indicator Yes Account Category SALES TRADING Active Account Yes FXC Variation Acct No Duty Type None Description S S S SZ LI Validation Default This is the account number of the General Ledger Code you wish Mandatory Blank to create Account numbers are categorised in the following number sequences 1000 1799 Current Assets 1800 1899 Fixed Assets 1900 1999 Intangible Assets 2000 2299 Current Liabilities 2300 2799 Disbursement Liabilities 2800 2999 Long Term Liabilities 3000 3999 Capital 4000 4999 Income 6000 9999 Expenses H3 Please Note If you are adding an account type of Disbursement Liabilities for example FREIGHT the system automatically adds the corresponding Income Account Type 42000 E g Account Number 2310 FREIGHT CUR LIABILITIES Account Number 4310 INCOME FREIGHT INCOME Ma T
40. ulk profits for o o Department s o Account Number s When the user enters the screen they first click on the Set Bulk Job Criteria button The below Screen will then display The user then can enter a customer code department code or Account Number In the below case the user wishes to display all Work In Progress Jobs where the Account Number 2430 Delivery Order Fee falls within the value range and needs profit to be taken up all Bulk Job Selection Registered Date between Customer Code Department Code Account Number Amount between Cancel Enter the customer code you wish to select Once the user hits OK the user then hits the Add Button and the system will display all jobs in that date range for Delivery Order Fee SYSTEM MESSAGE d The bulk job criteria that you entered is being used to obtain journal lines m Job Journal EXPEDIENT DEVELOPMENT 0 X File View GMA Maint Help i E Add Update Delete Find Browse Previous Next Set Bulk Job Criteria Job Journal Document Date Description Source JP JOB JOURNAL ADJUSTMENTS Job No Account No Departmer Client Description Amount 2 2000251 2430 VIS DEMCON DELIVERY ORDER FEE 30 00 2000251 4430 VIS DEMCON INCOME DO FEE 30 00 3002275 2430 VIS 4X4 DELIVERY ORDER FEE 55 00 3002275 4430
41. ve behavior is the same when you double click the Job No When you close this window the following message is shown You are about to Post xxxxxx Job Only Journal Do you wish to Proceed YES The record in this screen is posted and the user is directed back to the WIP Profit Screen If the full amount was posted then the Job will be removed automatically from this screen If sorted by WIP Only NO The entry saves in the Job Only Auto Profit screen and you are then directed back to the WIP Profit Screen The Job is still Shown in this screen IF System option AUTOJRLDOCDT is turned on the Doc Date in the Job Only Auto Profit defaults ETD for export shipments ETA for import shipments Please Note if either date is prior to the Oldest Date in the Company Details Masterfile or the dates are null the Doc Date will default to today s Date Output to CSV Extracts the data that is shown on the screen to Excel in CSV format 22 WIP Cost Code The Cost Code Report shows the Job Financial information for each Job No and is sorted by the Account Code and Department Code Please see below screenshot for the PDF Version e WIP Cost Code Time 13 57 04 Expedient Date 28 08 2015 Grouped by Account Code amp Department Code Cust Code Bill Number Date Reg Date Final Billed Paid Out Journals Balance DEPT NIA ACCT CODE 2300 ACCT DESCRIPTION DUTY GST AND CUSTOMS FEES DEMCON 5014817 13 03 2015 Account C
Download Pdf Manuals
Related Search