TABLE OF CONTENTS Pdf

Home

1. ieee eee es eRe ee M M A MM M a MM E 44 C ENEIDE E siccae e ad ue e DAE M FSET aR nce PEDE M Bre ciae 45 NE D Tad FIS TORI ORE P S 46 AMAN PENCINGE IIEPORTS Su i MIL E E RR I a SG Pads 47 APPENDIX A FEATURES OF CATSOFT ASSETS cccccccccscccccccccccccccccccccccccccccccccccccccccccccccccoccees 48 APPENDIX B FAQS FREQUENTLY ASKED 55 INITIAL SETUP amp INSTALLATION System Requirements Listed below are the basic requirements to operate Catsoft Assets Although these are the basic requirements we encourage the use of more powerful PC configurations in order to obtain the best results Intel Pentium based PC 166MHz and above 32MB RAM minimum 64 RAM Recommended MB Hard Disk space and above recommended 5 Window operating system MS Windows 95 98 ME 2000 XP Installing Catsoft Assets Version 4 04 1 Insert disk 1 into floppy drive A 2 To install click on Start Run in the field Open type in A SETUP EXE 3 An installation screen will appear it will say The program directory C Catsoft Asset40 The data directory C Catsoft Asset40 data If you have installed the main program in a different directory please change it accordingly Click Continue and when prompted to overwrite the existing file click Yes When the Ca
2. Book Depreciation Asset Status 11 Sort By From Ta Group By b al Cost centre Cost Centre Location Asset Code Purchase Date Depreciation Value Date Book to Begin ME ME ME 18 Report DEPRECIATION FOR JULY 1999 BOOR DEERECIA eed eee eei ee Eu ee dieere ertet CATSOFT ASSETS This period Thu 01 07 1999 Sat 31 07 1999 This year Thu 01 07 1999 Sat 31 07 1999 Company ACRON ACRON INDUSTRIES Run date Wed 1 3 2000 Page 001 DESC DEPR DEPRECIATION OPENING deem e DEPRECIATION CLOSING ASSET CODE PUR DATE TO BEGIN VALUE WDV PRIOR YEARS IHIS YEAR THIS PERIOD TOTAL WDV 0000000001 000 TOYOTA RAV 4 30 05 99 01 07 99 26700 00 26350 200 350 00 339722 33922 689 22 26010 78 0000000002 000 HONDA CRV 01 03 97 01 07 99 88000 00 70000 00 18000 00 1118 03 1118 03 19118 03 68881 97 0000000003 000 HONDA CIVIC 01 02 98 01 07 99 40000 00 30000 00 10000 00 508 20 508 20 10508 20 29491 80 0000000004 000 VOLKS WAGON NEW BEATLE 01 02 00 01 02 00 60000 00 60000 00 0 00 0 00 0 00 0 00 60000 00 0000000005 000 HONDA 52000 01 03 99 01 07 99 75000 00 74000 00 1000 00 952 87 952 87 1952 87 73047 13 0000000006 000 BMW 23 01 02 98 01 07 99 80000 00 75000 00 5000 00 1016 39 1016 39 6016 39 73983 61 0000000007 000 MG 22 08 98 01 07 99 60000 00 45000 00 15000 00 762 30 762 30 15762 30 44237 70 Total Company ACRON 429700 00 38
3. EL x iet E E ETE 22 IX DIE Se LAGE Che IEPENT en ane RW M T EE 23 PALAN INCC IRO era desi sped AP Lesser seca M 23 TRAN TER OFAN AY SC ee mm 25 e tea rie E ML eL S ML ELA 28 MOVE ASSETS FROM ONE COMPANY TO ANOTHER oso epo vH PUR 29 ACUI TONTTI ASDIC LAG dA M EL MAE DL EL M AE E LE LE EE LE ME 30 UNIO EA QE 32 CAPEX CAPITAL EXPENDITURE BUDGETS 2 1 cccccccccccccccccccccccccccccccccccccccccccccccccccecccccccoccees 33 CAPE XS BUDGE ENTRY 33 CAPEX DATAENIR SORE BING ceded tin ae det Pasa n eta eom nie aula 34 GAPEX ORDERADATAENTRY SCREEN os actu o den Odonis depen MM Ms agen eee ese 35 TRACKER REPORTS ostia eiiis desee eso eee asec aes ecce iris cedula Edo 36 EI I UE I a E Rr CM 36 DRP ACRE POR one ae cha se che ccs E 37 OUICK REPOR ES e ees Lee Ud LOL 38 UTILITIESAND MAINTENANCE 5 i eeoeeieocee voces lee que cle veu coe eo Eae e oup Qva ved eE cea ouo del eoe Eee 41 ee es 41 B VN Ez UM LW A 42 I P QUSE OWA SOTTO DEN MR EE TET COTTE MELO 44
4. Inserting a rate will cause the asset to begin depreciating again Default rates have to be entered via the Asset Type screen If the rate was meant to apply from the date book tax to begin then answer No to the freeze question If you only wish to apply the rate in the next period onwards answer Yes 57 Q3 A3 How to perform a quick backup using Winzip Winzip is by far the most popular convenient and reliable archiving method available We recommend its use in taking backups of your data especially if you are about to update the database but would like the peace of mind of having something to fall back onto and restore immediately in order to start over again if the outcome is not to your liking Ensure that you have Winzip installed before proceeding 1 Know what to backup your data is located in the DATA folder This could be on a network drive The current data path can be determined by referring to UTILITIES CHANGE DATA PATH Take note of the path then click Cancel to retain the path displayed 2 Exit program then click START RUN type EXPLORER and press OK 3 Using Windows Explorer navigate to the data path e g if the data path is XAASSETA4OWDATA select the X drive enter into ASSET40 folder and look for the DATA folder 4 Right click on the data folder and select Aad to ZIP o Under Add to archive provide a meaningful filename for the ZIP file e g if the backup was for the November 2002 p
5. CATSOFT ASSETS VERSION 4 04 TRAINING NOTES TABLE OF CONTENTS SEIUP A INSTALLATION sei cuia 2 MEN 2 INSTALLING CATSOFT ASETI T ERSON 4 Of c A bombe e ieee 2 Ac MD M D 2 REA C NN RNC 4 E OOO COT EL UN E TERIS 6 SUMMARY OF NEW FEATURES OF CATSOFTASSETS 4 04 ura eb ie suc Beles pada a dap bds tu 7 SETTING UPANEW COMPANY wee ee eee ee 9 iat oT ORE RI EA tee COMER ML dS E 9 SETIINGUP THE COMPANY S ETROUTIRE vc tete peu te OR Or odes aa bea ere ee Ute du inu pdt ww dee 10 AD ASS Cos EP EO OUR LER Sete een eR 10 eM Bee RINGS Gio mG OPN BION M e ete LM M Sr M MM ree aeRO M aed P NE 11 ES AB IANA ZUM AS E E T A A E A AET E AE 12 EO E A PE TN E EN inca 13 ASSETS WITH PRIOR YEARS DEPRECIATION FREEZING ASSETS EGER 16 EEE UIS N d Re EEA EEE ENESE E a EEE A E EEE 17 EO E OPE MIC A E A S 17 MAINTENANCE saadan aaa adaa aN 21 CHANGING DEPRECIATION OVERRIDE FIELDS Dues eed eei 21 PITS POS ATA II ZAG S MORI AT E acess dens E EEE EE 22 TO Eee Ne RO eR OEE EE x
6. Export Journal directly to GL and click on Screen Another method would be to save the report on disk and open it as a delimited text file in a spreadsheet which will appear in a comma delimited format 74 Q50 A50 Q51 A51 Q52 A52 Q53 A53 Q54 A54 Company Y requires three Costs on an Asset ie Book Tax and Fair Value Each needs to be depreciated and reported on Is this possible NB The tax rate of Book and Fair Value is the same Catsoft Assets make the allowance for four cost figures to be stored Purchase Price Deemed Value Depreciation Value and Taxation Value However only the latter two are used for depreciation purposes The Book depreciable value would be stored against Depreciation Value and the Tax depreciable value against Taxation value Fair Value could be stored against Purchase Price and Deemed Value however no depreciation calculations will be applied to either For depreciation purposes Catsoft Assets only stores two sets of figures i e for book and tax the user could create a third and store the information in a separate database This is made possible through the Change Data Path option Alternatively the user could create another company in the same database and store the information separately In both instances the user would have to key asset entry in twice Why are there no columns for addition and disposal showing on the Book Depreciation or Book
7. VO View Only E Editing Allowed VO A C E D A C E D NA FA FA FA FA NA NA FA FA FA NA NA FA FA FA NA NA FA FA FA NA NA NA NA FA pole ie fe e FA FA FA FA FA NA NA NA FA FA NA NA NA NA FA NA FA FA FA FA NA NA NA FA FA FA FA FA FA FA ARN pole ie fem A Additions Allowed D Deletions Allowed NA Not Accessible C Cloning Allowed FA Full Access Year 2000 Compliance Catsoft Assets stores dates in a Julian date format i e the number of days since 01 01 1600 recognising dates between 1600 and 3999 In version 4 04 dates are displayed in DD MM CCYY format The default century dates recognises the first 50 years in 2000 The year will still be displayed in full i e CCYY and can still be typed in full However for convenience where the user only keys in two digits i e 00 up to 49 the year will have a 20 defaulted in front of it while 50 to 99 will still carry a 19 in front For example 30 06 00 will be displayed as 30 06 2000 while 30 06 99 as 30 06 1999 Summary of New Features of Catsoft Assets 4 04 1 Depreciation Forecast Report his new report gives the user an added advantage to run a forecasting In the Update Assets entry screen the purchase price deemed value depreciation value taxation value and depreciation limit fields have been updated to recognise up to 9 digits plus 1 decimal Therefore the maximum amount allows to be entered for these fields is 999 999 999 90 NB Where all
8. Depreciation Journal Reports Although the Book Depreciation report in Catsoft Assets does not have the above columns it has additional filter functions for example allowing the user to obtain a report of disposals alone by changing the Asset Status and by limiting the date range the user can obtain purchases for the period A Movements report modelled after the Depreciation Schedule provided by the ATO can be obtained by selecting the Book Schedule option from the Report Type menu How does the program use the remaining life for each asset to calculate book depreciation Book depreciation is based on the depreciation method and rate selected which the user has to derive from the remaining effective life of the asset eg effective life of five years equates to straight line depreciation at 20 How does the program retain historical data such as original cost and prior accumulated depreciation when assets are transferred at WDV In the context of a data conversion an asset being imported into the database can retain its original cost and prior accumulated depreciation effectively transferring the asset in at WDV How does the program retain continuity of straight line depreciation calculations when the transfer value is not the original cost ie WDV In the context of a data conversion continuing from the answer above entering the asset in with its original cost and prior accumulated depreciation ensures that the
9. be handled If so how Details pertaining to any construction in process items can be done via the Maintenance module This screen allows the input of details such as the date of service labour cost part cost and service company to name a few A separate report can also be generated to display the details of the items that are under construction 70 Q30 A30 Q31 A31 Q32 A32 Q33 A33 need more details on entering budgets and running budget depreciation reports by month The Capital Expenditure CAPEX feature allows the user to create budgets allocate funds and ultimately commit to the purchase of the asset prior to updating the assets database The initial stage would be to set up the budget via CAPEX Budget The next stage would involve the phasing of the CAPEX i e the allocation of the funds in order to purchase the asset Once this is done the CAPEX Order comes into picture where the order is being placed for the asset A standard report is also available for CAPEX reporting purposes The report will give a clearer view of the budget phasing orders being made and the assets purchased In addition the user will be able to see whether or not sufficient budget has been placed in the acquisition of the asset Another useful report is the CAPEX depreciation forecast report which gives a forecast depreciation for budgeted amounts that have not been capitalised yet i e budgets that have not resulted in any pur
10. filter selection entered by the user and groups and sorts the asset items as required The report filter screen depicted below gives a good idea of the flexibility of options available in running any of the many reports in Catsoft Assets Depreciation reports detail totals across the selection for purchase price depreciation start value prior year current year and current period depreciation Report Filter Depreciation Report E Company Code 99h Catsoft Demo Report Heading Report Asset Status Group By Department Department Cost centre Cost Centre Asset Type Asset Type Location Asset Code Purchase Date Depreciation Yalue Date Book to Begin 5 2 List missing Assets and value for a location check following an asset check by PDE Catsoft Assets when fitted with the optional bar code module generates scanner reports detailing the actual assets scanned by the bar code reader during an audit and after comparing these to the existing database record generates exception reports Exception reports do not detail the written down value of the assets that have not been scanned concerning themselves more with a comparison of the discrepancy between the allocation according to the bar code reader and the allocation according to the database However a custom report can easily be written using our Quick Reports custom report writer that isolates assets for which the field date last scanned does not match the o
11. mail For more information please contact Catsoft Sales Can Catsoft Assets identify asset by Company Location and Cost Centre for up to 5 entities with the ability to transfer assets at will Yes Within the Company you have the option to allocate assets to particular Locations Cost Centres Asset Types etc You also have the option of moving the assets with the function Move Assets from one company to another company Can Catsoft Assets do a tracking of Capital Works in Progress expenditures and transferring to asset register Yes Catsoft Assets has a report called Capital Expenditure CAPEX Budget option that monitors commitments and purchases against budgets Depreciation can also be forecasted based on the budget Once the CAPEX budget and phase has been set up it can be linked to the asset in Update Asset Items when the asset is purchased against the budget However the budget can only be applied to a new assets or assets using the same Asset Type code Can Catsoft Assets enable Book and Tax Depreciation in compliance with accounting standards for approximately 5000 assets There is no set limit on how much assets can be stored in the Catsoft Assets and it can cater for Book and Tax Depreciation for these assets Can we export the GL Depreciation Journal in CSV format You can export the GL Deprecation Journal in CSV format by clicking on Reports Export Journal Entity Entry Data Then select a Report Type untick the
12. nine digits are used the last decimal disappears Depreciation Forecasting reports enables the user to run depreciation forecast report for assets over a future period of up to 5 years It gives a breakdown of the depreciation charges of the assets for each month over the selected period of time For convenience purposes these reports can be saved and exported out onto a file in ASCII text format Thereby allowing the user to view the report in Microsoft Word or Excel consult your MS Word and Excel user manual for further instructions The Export Journal Entry Data now have six specific report types added on to them It provides the users additional options to run depreciation journal entry from the various combination of department cost centre or asset type categories The new journal export routine now has the ability to create report files that can be converted to Attach Business Partner or Attach Catapult format The suggested ledger entries report can also be exported and viewed in ASCII text format orecastina report for both book and tax 3 depreciation of all assets for a future period of up to five years From the main menu bar select Reports then Depreciation Forecasting The report filter allows the user to limit the selection of assets to a specified range In the date selection enter the date range you wish to forecast the depreciation of the assets for This report displays the depreciation rate a
13. of the current period is entered into the Prior Years column When saving the entry the user will be prompted with the freeze question to which the user should answer Yes If No was chosen the asset may not depreciate if accumulated depreciation is overstated or depreciate too much if accumulated depreciation is understated in the next period Under or overstatement of depreciation is determined from purchase date up to the end of the next period As a history of rates is not stored the written down value of the asset would be inconsistent with the current rate of depreciation specified when the asset is entered Solution delete the entry and re enter it into the database with the accumulated depreciation updated to the end of the period save and freeze If a Depreciation Limit is specified lf a Depreciation Limit is specified then the asset stops depreciating for book purposes if its book written down value equals the Depreciation Limit i e the book written down value will not go below the depreciation limit amount By removing the Depreciation Limit the closing down value should not be greater than the depreciation limit because this will cause the asset not to depreciate A depreciation method is specified with a zero rate of depreciation If a depreciation method is entered but a rate is not specified the rate used is 0 00 Check both the default rates and the overriding rates in the assets entry screen
14. on entering budgets and running budgets depreciation reports by month Can leased assets be included We have disposed of an asset and then 2 months later we received money for it Are we able to reverse the disposal How do we clone an asset 55 basis Can this be set 34 Our accounting month is on a 4 4 5 w depreciation calculation 35 How can you assign an asset to a person 36 What is the Export Journal Entry Data Report 37 Company X would like to create a Parent Child relationship within Catsoft Assets and would like to be able to report on this 38 Before rebuild the indexes how can get the original report 30 that was backed up 39 When we revalue assets the system only r value and the Tax jue Is there a way that the Tax value can b tbe al er ed las well What is the process of rolling over into a new financial m Ge roll back to my last financial year from 30 06 2003 to 30 06 2002 2 Should not close off apa ids year before roll back to 30 06 2002 Will the opening writt W 07 2002 b osing written down which froze c on die 30 06 2002 up accordingly for June 2003 value 44 f client have processed a couple of End of Periods and are now in the month of October All financials have been completed for the month of ia alias i pieni Forgot to add in an asset that they want to depreciate sin is 1
15. screen e Details of the purchase L C no Can view the licence number via going into Help and then selecting About e Cost of purchase which may include other purchasing costs in addition to the invoice value ex Freight transport charges labour cost You can enter the cost of the purchase including any additional purchasing cost through the Update screen in the purchase price field e Category of the asset In Catsoft Assets when you enter your asset categories groups details it should include the depreciation method applicable This screen is compulsory and forms the basis for the Assets screen and other activities Asset Type Code Mandatory section that identifies the asset type Asset Type Description Include a brief description of the asset type in this section Depreciation Method To calculate the depreciation you can use of the following methods Straightline S Reducing Balance R Units of Usage U or Immediate Write Off 1 65 General Ledger Accounts Codes in this section will be referred to in some of the reports and when exporting journal entries Revaluation Index This will have no effect on related assets unless the user executes the Revaluation by Indices routine The index is stated in decimal 1 000 being equivalent to 100 e Location A company s structure consists of Departments Cost Centres and Locations Every company must have at least one department and one cost centre but the use of Loca
16. 0 00 7398 08 500 00 203 84 101 92 703 84 7296 16 5 200 01 07 97 01 08 99 8000 00 7445 64 500 00 156 28 101 92 656 28 7343 72 Total Company TF 16000 00 14843 72 1000 00 360 12 203 84 1360 12 14639 88 Deduct depr of disposals 0 00 0 00 0 00 0 00 Add balancing item in transfers 0 00 Deduct depr of disposed transfers 0 00 0 00 0 00 0 00 0 00 Deduct depr of revalued assets 0 00 0 00 0 00 0 00 Total after adjustments 16000 00 14843 72 1000 00 360 12 203 84 1360 12 14639 88 Both assets were overridden with a depreciation rate of Book 15 and Tax 20 Straight line Asset 5 200 was frozen after changing the depreciation overrides and prior to rolling forward as shown by the date book to begin Depreciation has been calculated at 8 from 01 07 99 to 31 07 99 and at 15 from the date frozen ie 01 08 99 to 31 08 99 as shown below 8000 08 365 31 8000 15 365 31 156 28 Asset 5 100 was not frozen after overriding the depreciation rate The result is that the depreciation has continued to calculate but the This Year depreciation column is incorrect It has calculated depreciation at 15 from the 01 07 99 to 01 09 99 when it should have calculated the depreciation as above 8000 15 365 62 203 84 5 Exercise 6 In our example all motor vehicles are depreciated at a book rate of 15 and Tax at 20 If we call up asset number 0000000001 through the update asset items screen we can change the depreciation rates fo
17. 03 1998 01 03 1998 01 03 1998 80000 80000 80000 80000 No 5000 5000 0000000007 000 MG 1 Motor Vehicles Administration Northern City 22 08 98 22 08 98 22 08 98 22 08 98 60000 60000 60000 60000 No 15000 15000 Assets with prior years depreciation Freezing Assets The depreciation for prior years field is used when 1 an asset is being entered into the system for the first time and 2 the asset has prior years depreciation applying to it Any prior years depreciation should be entered in this field after which the asset must then be frozen Freezing ensures that the old depreciation amounts that is whatever depreciation that has been calculated to the current period are held at that point in time enabling Catsoft Assets to continue calculating depreciation with new depreciation rates After entering assets with prior years depreciation the program will ask you if you wish to freeze the asset Click on yes For book purposes For tax purposes 2 you want to freeze the asset 2 you want to freeze the asset The following illustration shows the difference in depreciation values for an asset that has been frozen and an asset that has not been frozen gt Illustration Number 1 Dummy Company Freeze Depreciation Mack Trucks Shows one months depreciation 01 07 99 31 07 99 Asset Purchase Date Purchase Book prior Book this Book this Book at WDV for code date book to price y
18. 0350 00 49350 00 4697 01 4697 01 54047 01 375652 99 Deduct depr of disposals 0 00 0 00 0 00 0 00 Add balancing item in transfers 0 00 Deduct depr of disposed transfers 0 00 0 00 0 00 0 00 0 00 Deduct depr of revalued assets 0 00 00 0 0 00 0 00 Total after adjustments 429700 00 380350000 49350 00 4697 01 4697 01 54047 01 37565299 Legend of flag d indicates partial disposal of asset t indicates partial transfer of asset I indicates transferred in D indicates full disposal of asset T indicates full transfer of asset W indicates full depreciation of asset 19 MAINTENANCE Changing depreciation override fields The depreciation overriding function allows different rates to be applied to individual assets within an asset group gt Illustration Number 2 In the illustration below the computer asset types had an original depreciation rate applied at Book 8 and Tax 10 Straight Line BOOK DEPRECIATION CATSOFT ASSETS This period Fri 01 08 1999 Sun 31 08 1999 This year Tue 01 07 1999 Sun 31 08 1999 Company TF TOTAL FORMS P L Run date Thu 30 10 1999 Page 001 DESC DEPR DEPRECIATION OPENING e CLOSING ASSET CODE PUR DATE TO BEGIN VALUE WDV PRIOR YEARS THIS YEAR THIS PERIOD TOTAL DEPR WDV 5 100 01 07 97 01 07 99 800
19. 07 1999 This year Thu 01 07 1999 Sat 31 07 1999 Company ACRON ACRON INDUSTRIES Run date Wed 1 3 2000 Page 001 DESC DEPR DEPRECIATION OPENING DEPRECIATION CLOSING ASSET CODE PUR DATE TO BEGIN VALUE WDV PRIOR YEARS THIS YEAR THIS PERIOD TOTAL WDV 0000000002 000 HONDA CRV DISPOSAL OF ONE HONDA CRV 01 03 97 01 07 99 d 577 05 0000000002 000 HONDA CRV 01 03 97 01 07 99 44000 00 35000 00 9000 00 559 02 559 02 9559 02 34440 98 Total Company ACRON 44000 00 35000 00 18000 00 1136 07 559 02 19136 07 34440 98 Deduct depr of disposals 9000 00 577 05 0 00 9577 05 Add balancing item in transfers 0 00 Deduct depr of disposed transfers 0 00 0 00 0 00 0 00 0 00 Deduct depr of revalued assets 0 00 0 00 0 00 0 00 Total after adjustments 44000 00 35000 00 9000 00 559 02 559 02 9559 02 34440 98 27 Full Disposal The same procedure applies although units to dispose should be set to equal the no of units In this case since there is only one unit left to dispose of the Units to dispose should be set to one Balancing Charges A Balancing Charge is the profit made when an asset is disposed for more than its written down value but less than its original cost This profit is tax assessable This function allows you to apply these Balancing Charges to new assets to offset any tax that the company may be charged i Exercise 7 Firstly lets dispose of an asset for an amount more than its written d
20. 10 will be added to the Total Depreciation of the Transferred In asset 276 64 all other periods depreciation for the remainder of the year to equal the Prior Years depreciation for the Transferred In asset 27 Bulk Transfer Go to the Routines menu and under Update Asset Items select Bulk Transfer Bulk Transfer Company Code ACR H From Department ADHIN Cost Centre HORTH Location CIT This routine allows you to transfer one or more assets at a time from e one code to another within the same company within the same structure on the same level Eg an asset or group of assets can be transferred from Dept 1 to Dept 2 within Company A e combination of codes as above to another at the end of the current period Eg on 31 08 99 Note Transfer reports can be obtained to identify such assets This routine only caters for Full transfers Partial transfers have to be done on an individual basis via the Transfer routine 28 Move Assets from one company to another This new function enables the relocation of an asset record or a number of assets from one company to another It is unlike transferring an asset in Catsoft Assets in that it does not divide the depreciation between the asset before and after the transfer The asset simply gets a new company code Hove Assels EW Current Company ACROH Move to Company Range Department Cost Centre Asset Location Code Asset Code Purc
21. Ageing Report The Ageing report gives a listing of assets within their respective age groups over 9 years e Disposals Report The Disposals tracking report supplements the existing standard Disposals Report by maintaining a record of assets disposed in over a year ago effective from the date of installation e Moving Assets from one company to another This function enables the relocation of assets from one company to another SETTING UP A NEW COMPANY Setting Up a Company In order to set up a new company go to the File menu and select Company or alternatively click on the company icon from the Entry Screens tool bar ndz LTD Click here Exercise 1 Type the following Company Code ACRON Company Name Acron Industries Company Lx 212 121 212 Tax File Number ACROH IHDUSTHIES ACH 123 456 789 START DATE This Period Dates Book Basis 202 86 1999 Tax Basis 387 66 1999 Company Code Company Name Comment Line END DATE 38 86 1999 Last Year Dates Book Basis Tax Basis This Year Dates Book Basis Tax Basis General Ledger Accounts Loss On Sale L0SS SALE Profit On Sale prRorit saLe sundry Debtors DEBTORS sundry Creditors CREDITORS Loss Rewal LOSS REVAL Revaluation Reserve REU RESERUE Save Cancel Establish the starting dates for your current financial year here Setting up the Company s structure A compa
22. Catsoft Assets To do that go to Catsoft Assets Program select Utilities Change Data Path and specify the data path for the new blank database e g C catsoft assets40 blank Click on the OK button Catsoft Assets will then prompt a question Directory does not exist Do you want to create Select YES 62 A new blank database will then be created in C catsoft assets40 blank Exit the Catsoft Assets program go to windows explorer and select C catsoft assets40 blank Copy the blank DISPOS A DBF and REVAL_AU DBF files in the blank folder and copy them into C catsoft assets40 data After that go to Catsoft assets select Utilities Change data path and change the data path back into C catsoft assets40 data Click on OK and then type in the Username and password In Catsoft Assets select Routines Freeze Depreciation Click on the Book and Tax tab at the bottom of the Freeze Depreciation window and click on the OK button When the freezing process is completed the program will indicate how many assets have been frozen Roll the period to the start of the financial year e g 01 07 2002 To do that go to Routines Cycle End End of period In the To field of the Next period dates specify 30 06 2002 1 day before the desired date Click on Yes to proceed Next unfreeze all the previously frozen assets To do that select Routines Unfreeze Depreciation Click on the Book and Tax tab at the bottom of the UnFreeze De
23. Code Asset Type Description PHASING OUT ACRON BUDGET ea im 6 alphanumeric characters ave Cancel When you are ready to phase out a budget enter relevant details here This screen s primary purpose is to store funds allocated for a CAPEX Budget created earlier The search key is CAPEX Budget Code CAPEX Phase Code Estimated Date This field requires the date you estimate when funds will become available for allocation to the related budget record Budget Amount Enter the budgeted amount that is going to be phased out in this field Length 10 digits Maximum amount 99 999 999 99 34 ORDER CAPEX Order Data Entry Screen CAPITAL EXPENDITURE CAPES ORDER xX Company Code CAPEX Order Code Capex Budget Code Asset Type HEV ASSET HOTOR VEHICLE i New i Replacement Unique identifier for an Order Capitalisation Date 9170771999 record Comment HEW ASSET Maximum length iL Capex Order 6 alphanumeric characters Order Date 25 86 1999 Order Amount 100 000 00 Description PURCHASE ORDER SENT Once an order for the budgeted asset has been placed enter relevant details into this screen After phasing out a budget you will then be in a position to order the asset Fill out the order details in this screen Then after the asset has been acquired fill out the Update Assets Screen to record the purchase The search key for
24. File 40 UTILITIES AND MAINTENANCE CEN Web AE Entry Screens bilities There are additional tools within Catsoft Assets that are listed under Utilities These include a Backup and Restore facility and an Export function Other tools not represented by icons include Rebuild Index Change Data Path and Users which are options available under Utilities on the Main Menu bar Maintenance Reports Maintenance Data Entry Screen g7 Entry Screens Utilities A Maintenance The Maintenance Data Entry Screen or Maintenance History screen gives you the ability to keep track of costs and related details in maintaining assets within the register The related reports section translate this information into a Utilisation Report and a Maintenance Cost Summary Gel Backup Data to Disk This utility was designed to provide users with the convenience of backing up their data to one or more floppy diskettes The designated drives should either be A or B If C is designated then Back Up Data Please enter drive A or the backup file will be saved to the b root directory 41 Once a drive is selected the following window will appear displaying the codes for all existing companies from which you can make a selection for backing up Make your selection by clicking on the appropriate check box Multiple PickList Catsoft Demo Total Forms P L Total Peripherals P L Clicking on this Total Peripheral
25. Insurance Index 1 0000 if no change Edit Add Clone Del All of the above screens become picklists when the user enters data into the main update asset entry screen see below Note that we do not have a sub location field in our database although we would be glad to discuss your requirements with regard to this field to investigate a possible alternative means of achieving your desired record keeping and reporting capability 49 Update Assets Desc Test Asset Form 2 Company Code 996 Asset Code Asset Type THHURI 4 Immediate Write OFf Demo Serial No Department 1 Sz Department 1 Supplier 2 Cost Centre Loci E Location 1 Purchase Date Date Book to Begin Deemed Date Date Tax to Begin Purchase Price Depreciation Value Deemed Taxation Value Depreciation Limit Apply S 57AF Capital Gains Method Private Use 56 max Tax Effect Operating Hours Day rn Capex Budget Capitalisn Date Capex Order Sz 89 08 d 8B at Default Book 1 9 982 Units L 4 0 06 Overriding Book Units Tax 8 86 9 90 Units Used to Date CostCentre Location Depreciation Prior Years This Year This Period At Freeze 8 8 300 08 0 08 0 00 8 88 Hb 366 66 HB Written Down Values Book 8 88 8H Tax 8 08 00 Insurance Company Pony Insurance Premium Insurance Value Insur Expiry Dat
26. OR JULY 1999 This period Thu 01 07 1999 Sat 31 07 1999 This year Thu 01 07 1999 Sat 31 07 1999 Company ACRON ACRON INDUSTRIES Run date Wed 1 3 2000 Page 001 DESC DEPR DEPRECIATION OPENING DEPRECIATION CLOSING ASSET CODE PUR DATE TO BEGIN VALUE WDV PRIOR YEARS THIS YEAR THIS PERIOD TOTAL DEPR WDV 0000000005 000 HONDA 52000 01 03 99 01 07 99 I 75000 00 72370 90 0 00 0 00 0 00 72370 90 0000000005 000 HONDA S2000 TRANSFER OF S2000 TO SALES 01 03 99 01 07 99 T 1000 00 1629 10 Total Company ACRON 75000 00 72370 90 1000 00 1629 10 72370 90 Deduct depr of disposals 0 0 Add balancing item in transfers 0 00 Deduct depr of disposed transfers 0 00 0 00 0 00 Deduct depr of revalued assetg 0 00 0 00 Total after adjustments 75000 00 72370 90 1000 00 1629 10 72370 90 The T indicates that the asset has been fully transferred The asset is now inactive and will This equals the depreciation figure from prior years plus the depreciation between the last end of period run and the transfer date be deleted once the End of Year is run Total Depn 1000 75000 15 366 53 days 1000 1629 10 2629 10 The fully transferred asset will have a prior years depreciation figure which is equal to the total depreciation from the old asset plu
27. Units Asset Type Department CostCentre Location Purchase Price 526 708 88 Depreciation Value 526 788 88 Date Book to Begin e17 87 1 999 Revaluation Details 10000 00 15 89 1999 REVALUATION OF TOYOTA RAY New Asset Value Hevaluation Date Description of Revalue REVALUATION HISTORY CL ASSETS Fun date 3 03 2000 Company ACRON INDUSTRIES Page 1 RBVALLITN REY LLLA TICIN PREVIOUS DBFRBCIATM REVALUATION DATE ASSET CODB DESCRIPTION YALUE VALUB DATE L JCHANGB WRITTN BACK CHANGE iiss Oo coo IOYOIARAV4 30 000 00 24 700 00 GOT sg 3 300 00 1 131 64 4 48 1 4 Total Company ACRON 30 000 00 26 100 00 3 300 00 I 131 64 4 481 64 32 CAPEX CAPITAL EXPENDITURE BUDGETS This is a fully integrated facility which allows you to create Capital Expenditure Budgets and then monitor commitments and purchases against budgets Depreciation can also be forecasted based on the budget Once the Capex budget and phase has been set up it can be linked to the asset in Update Asset Items when the asset is purchased against the budget Be CAPEX Budget Data Entry Screen CAPITAL EXPENDITURE CAPE BUDGET Company Code CAPEX Budget Code Capex Budget Code acron eu asset Unique identifier for a Asset Budget Description MOTOR UEHICLE Maximum length 6 alphanumeric Book Depreciation Basis STRAIGHTLINE characters 2 Book Depre
28. al for tax purposes can be found via running tax disposal report Insurance Detail of insurance cover taken type of insurance policy no This field is optional for the purpose of tracking and reporting on all the assets that have Insurance details Insurance Company The name of the Insurance Company is entered here Policy Number The insurance policy number is entered in this section Insurance Premium The insurance premium paid for this asset Insurance Value The amount for which the asset was insured for Insurance Start Date When the insurance policy starts Insurance Expiry Date When the insurance policy expires Sum insured The insurance value can be entered through the Update screen for the asset Related premium The insurance premium can be found in the Update screen 67 Q20 What are the main additions or disposals reports for a given period in the Catsoft Assets program A21 Reports Breakdown of each class of assets giving the cost accumulated depreciation and written down value giving the b f balance additions disposals transfers and closing balance These reports are available under the Reports section Breakdown of the total assets giving the above information This section is available through going into Reports and selecting the type of report you want List of assets by location You can run a purchase report and sort the report by location List of additions during the year A purchase repo
29. an one file click on OK If you want all available fields in the selected database to appear in your report click x here All Quick Reports have an extension of QRP To select either double uU 2 pw click on the file or highlight wareport then click on OK auickReot H The above window will appear if you clicked on 38 2 Select the fields you would like to appear on your report Each DBF file has a number of fields that you can select from If you did not mark when selecting the report in step 1 then a list of these fields will appear for you to select one at a time F3 Quick Report untitle qrp Assets To move this box click on this bar at the top and drag the box to a new location on the screen Quick Report Title Once on the report click once to release normally the field should be placed within the Details section Add Database Fields nm Asettode s Sub Code Company Code Description um of Units The fields are arranged in screen format order Simply point at the field and double click A hand 2 will appear over the field allowing you to drag the field onto the report Selected field s TetAssetCode 0 2403997 4 3 Create a scope for your report i e a selection criteria Click on the desired field then click on Edit and select Scope The set up behin
30. applying the 2259 18 balancing charge f Apply the Tax Profit of 5549 18 the new asset If you do not wish to apply the full amount the remainder will appear in under Available which can be applied to another asset on the next line or carried forward to the next period After executing this routine asset number 0000000008 will be updated with reduced depreciable amounts for tax purposes Go to the Update Assets Entry Screen and you will notice that the Taxation Value has been reduced by the Amount Applied above 5549 18 Update Assets Company Code ACRON Asset Code ELT Desc HX5 4 Number of Units Sg MOTOR VEHICLE No Sz SERUICE Supplier Asset Type Department CostCentre SouTH SOUTHERN REGION Location Tal CLAYTON Purchase Date 15 99 1999 Date Book to Begin 15 09 1999 Deemed Date 1 89 1999 Date Tax to Begin 157 99 1999 Purchase Price 48 008 68 Depreciation Value 46 008 08 Deemed Value 46 000 08 Taxation Value 34 550 82 Apply S 57AF Capital Gains Method Private Use 56 8 08 Tax Effect Operating Hours Day The Taxation Value has Capex Budget B Capitalisn Date been reduced First Prior Next Last Edit Add Dei by 5549 18 24 Transfer of an asset This routine allows you to transfer one asset at a time from 1 its existing asset cod
31. assets are transferred in at WDV and there is continuity in straight line depreciation calculations 75 Q55 A55 Q56 A56 Q57 A57 Q58 A58 Q59 A59 Q60 A60 How does the program extract the data for planning Assets can be exported out as a text delimited file using the Export function in the Utilities menu and opened and manipulated in Excel for planning purposes Alternatively a depreciation forecast for these assets for up to a maximum of five years from the current reporting period can be obtained by selecting Depreciation Forecasting from the Reports menu output as a text delimited file to be used in Excel for planning purposes How does the program import initial data Once the data is finalised and arranged in Excel Spreadsheet according to our import specifications we can then import them into the Catsoft Assets database Please note that a fee will be quoted upon review of those finalised spreadsheets Please contact Catsoft Sales for further details Company A is using one database for the fixed assets This database includes two NZ branches where the amounts entered are in NZ dollars How can we extract these two NZ branches from the existing database and transfer them to a new NZ only database In order to transfer a company to another you must ensure that both companies This Year and This Period Dates are the same To perform the procedure simply go to ROUTINES MOVE ASSETS Plea
32. ay need to refer to the appropriate manuals for further information Rebuild Index Hebuild Index 3 vou wish to proceed Certain circumstances may arise during the course of using Catsoft Assets that may result in your database index files becoming damaged This will normally result in slower processing speeds in particular when running reports If that ever happens select Rebuild Index and click on the index files contained in your current data path will be rebuilt These index files are used for referencing records within each data file contained in your current data path Hence your data is not affected by the rebuild To change your current data path setting select the Change Data Path option discussed next 44 Change Data Path This option allows the user to change the data reference path toa new designated data path c asset40 data OK The data files have an extension of DBF hence if you scroll down and identify files like ASSETS DBF etc then it is very likely that this path is a Catsoft Assets data path E c no volume label The default data path is set up when you install the program in this case C ASSET40 DATA The path is automatically set to this unless you change the data path Once you have changed the data reference path e g to C ASSET40 DATA2 the next time you run the program it will automatically refer to this new path If the data path refe
33. ce History entry screen 47 Appendix A Features of Catsoft Assets 4 04 Asset Database Catsoft Assets has a multi level database with all assets allocated according to company cost centre department location and asset type Separate databases store comprehensive information for these levels and as such rather than the user having to type a description of departmental or other allocation for each item they need only pick the relevant department from a list and pre entered descriptive details are displayed on screen The user can enter as many companies departments cost centres locations asset types and asset items as required up to 99 999 The various screens are displayed below and give a good indication of the variety of data that can be stored on the database Company EI 100 866 Hd Tax File Number Catsoft Demo Software Trading START DATE END DATE This Period Dates Book Basis 2 21 125 0170172000 Tax Basis H3 81 1907 6170172006 Last Year Dates BookBasis 38 06 1996 Tax Hasis i f 30 86 1996 This Year Dates Book Basis Tax Basis Company Code Company Mame Comment Line General Ledger Accounts Loss On Sale 0SS SALE Profit On sale lt sundry Debtors DEBTORS sundry Creditors CREDITORS Loss Rewal LOSS REVAL Revaluation Reserwe REW RESERUE First Prior Next Last_ Edit Add Clone Del Department E3 Departm
34. chases Catsoft Assets has an additional feature i e the depreciation forecast report The user can utilise this function to generate depreciation reports for future periods Alternatively the user can choose to roll the period to the point where the forecast is expected and print the depreciation report Can leased assets be included Leased assets can be included in the register as normal assets but this does not accommodate details such as the fair value residual value interest rate etc Contrary to that we do sell a separate lease program i e Leasecat If you are interested in looking to purchase this as well do let us know and we shall provide you with the necessary information We have disposed of an asset and then 2 months later we received money for it Are we able to reverse the disposal When an asset has been disposed of you will not be able to do any alterations unless you have a backup In addition figures within the reports can not be altered due to the fact that these figures are not stored and is only generated when the report is run It is highly recommended that you do a backup before proceeding in the disposal as these routines can not be undone How do we clone an asset Cloning an asset would result in all information remaining the same except for the asset code which you will have to add change To do this please follow the instructions 1 Go to the Catsoft Assets program and click on the Update Assets Scr
35. ciation m 08 if S Units of Usage a if U Mew Replacement Capitalisation Date Total Budget Comment Enter your budget details here This screen is applicable to the preliminary planning stage of the budget i e before phasing out a budget and ordering a budgeted asset The details above excluding the Budget Code are required to calculate depreciation in the CAPEX Depreciation Forecast Report The Asset Type that you select will determine the depreciation method used The budget can only be applied to a new asset or assets using the same Asset Type code Capitalisation Date Enter the estimated capitalisation date of a budgeted asset here this date is normally recorded as the Date Book Tax to Begin fields in the Update Assets Screen after the asset is acquired This date will be used as a reference point from which depreciation will be calculated in the CAPEX Depreciation Forecast Report Total Budget Enter the estimated value of a budgeted asset here Maximum length 10 numeric characters Maximum amount 99 999 999 99 33 FHASE lt CAPEX Phase Data Entry Screen CAPITAL EXPENDITURE LAPEX PHASING HEU ASSET HOTOR VEHICLE Mew Replacement Capitalisation Date 01 07 1090 Comment HEW ASSET CAPEX Phase Code Capex Phase Code Estimated Date 207 06 1999 Unique identifier for a Phase Phase Amount 100 000 00 record Maximum length Company Code ACROH Capex Budget
36. ciation prior to the 01 07 2002 i e 2800 up to the 30 06 2002 59 Q6 A6 Some assets companies missing from the database There are cases where the user realises that they have lost their data completely or lose some assets within a company file or lose a specific company from the company list In such situations check the following Ensure that the data path is correct There is a high likelihood that the user entered the company data in a specific data path which has since been set or reset to point to a different path Check the current data path the program is pointing to Click on UTILITIES CHANGE DATA PATH lf the data path is incorrect please change it to what it should be Note that in circumstances where the user does not know the data path search for the file ASSETS DBF either by using the Windows Find function This will give you a list of probable data paths FIND function click on START FIND FILES or FOLDERS Under Name amp Location next to Named type ASSETS DBF click on Browse and change the drive you would like to search click on Find Now to commence search A list of files along with the folders they are in will appear Take note of these If the alternate path is selected correctly the user will be prompted for a username and password Note f the path does not exist you will be prompted to create the path instead and if the database does no
37. cumulated depreciation will be adjusted To check this revaluation go to the Reports menu and select Revaluation Report Your report should like the one below REVALUATION HISTORY a CATSOFT ASSETS Fun date 01 3 2000 Company ACRON ACROM INDUSTRIES Page l RBVALLITN REVALUATION PREVIOUS DEPRECIATN REVALUATION DATE ASSET DESCRIPTION YALUE VALUE DATE CHANGE WRITTH BACH Sos ooo EMW Z3 946 400 00 JG OGOGO OGT Lg amp doo oo 7 052 77 13 452 79 Total Company ACRON 8d 400 00 BG r rAr 6 400 00 7 032 77 13 432 77 The asset has been revalued up by 8 80000 00 1 08 6400 Note 1 If the cost of the asset is to be revalued you must apply the Revaluation Index to either the Depreciation Value or the Written Down Value of the asset 2 If the insurance value is to be revalued the Insurance Index will be applied to the Insurance value of the asset 3l Revaluation of an Asset This routine enables the revaluation of a single asset to a specified dollar value i Exercise 10 Under Update Asset Items in the Routines menu select Revaluation or simply click on the Revaluation icon from the Routines tool bar nal Click here 210000 Enter in the following Asset number 0000000001 New Asset Value 30000 Revaluation Date 15 09 99 REYALUE AN ASSET Asset Details Company Code ACROH ACRON IHDUSTRIES AssetCode eaa rovorn RAU 4 Serial No No of
38. d Scope is similar to the standard report filter the only difference being that more fields can be selected Please refer to an earlier section entitled Standard Report Filters in this chapter Use this scroll bar to view the rest of the fields Click on this square tab and drag downwards 4 Edit the format of the report to produce the desired report presentation The report title for example can be altered by double clicking it and then keying in a more suitable title Text Dialog Quick Report Title Other features include being able to cut copy and paste by clicking on Edit and selecting the relevant action inserting a blank line data fields text fields special fields such as record count and page number Sub totalling and Grand totalling numeric fields by clicking on Insert and deleting a field or a line by clicking on Delete 39 5 Save your report f you wish to re use this report it is advisable to save the report at this All Quick Reports have an extension of QRP Key in the desired filename E preferably 8 characters in I length excluding the extension 6 stage Click on File and select Save or Save As if you wish to save the report under a different name 7 Run the report The report can either be previewed on the screen sent to the printer or exported out onto a file in ASCII text format All these options can be selected by first clicking on
39. de ACRON Asset Code Desc TOYOTA 4 Number of Units Asset Type 8 MOTOR VEHICLE Serial No Department sales z sSRLES MARKETING Supplier NORTHERN REGION CLAYTON CostCentre NORTH E Location Purchase Date Date Book to Begin Deemed Date Date Tax to Begin Purchase Price 26 700 00 Depreciation Yalue 26 700 09 Veit Taxation Value Depreciation Limit Apply S 57AF Capital Gains Method Private Use 56 8 88 Tax Effect Operating Hours Day a Capex Budget DS Capitalisn Date First Prior Next Last Edit Add Clone Del E NB In order to access the second page of the assets screen either arrow down or page down Update Assets Capex Order gg Default Book is 15 68 Units rw 20 882 Overriding Book Units Tax 9 90 e 88 00 Saf Units Used to Date Depreciation Prior Years This Year This Period At Freeze p 358 08 Bad 50 8 50 8 5 8 na08 08 Bad p B EE Bd Written Down Values Book 26 358 88 358 88 Tax 26 388 88 388 88 Insurance Company _ eee Policy No Insurance Premium Insurance Start Date Insurance Value Insur Expiry Date zu Barcode a E Date Scanned Time Scanned Date Changed 2870272000 Time Changed 11 56 00 First Prior Next Last_ Edit Add Del Upon saving assets with prior years depreciat
40. e RR Insurance Start Date HE Barcode Date Scanned Time Scanned Date Changed 94 69 1998 Time Changed 16 51 00 First Prior Next Last Edit Add Clone Del Note that the above screen scrolls as the user enters data Disposal details are not stored in the actual asset database and as such do not appear in the screen above We have a separate database to store details of disposals and the user can run reports at any time whether to screen printer or file for details on disposals When an asset is disposed of disposal proceeds and sale expenses can be entered into the disposals screen see below as well as reasons for the sale which are detailed on the disposals reports 50 DISPOSE OF ASSET E3 Asset Details Company Code 998 Catsoft Demo Asset Code wen Test Asset Form 18 No of Units 1 Asset Department CostCentre Location Serial Purchase Value 308 68 Deemed Value 2300 00 Depr Start 81 11 1996 Deemed Date 81 11 1996 250 00 Sale Expenses 25 18 11 1998 Units Disposed Unit no longer required Selling Price Dispose Date Description of Disposal Management amp Reporting 1 List assets and total value by selected location or sub location and or by category The most practical way to run an asset listing report is to select a book or tax depreciation report which lists all assets according to the
41. e Book to begin is later than the next period start date appeared Assumption This year begins from 01 07 2002 and the current period is 01 04 2003 30 04 2003 An asset with prior years depreciation and date book and tax to begin as at 02 05 2003 is entered into the system When selecting YES to freeze the asset a message Date Book to begin is later than the next period start date appeared When a user freeze an asset the program will begin depreciation for the asset from the date at which the freeze takes place The error appeared because the asset s Date book and tax to begin is 02 05 2003 which is later than 01 05 2003 To resolve the situation 1 Edit the asset 2 Change the date book and tax to begin to 01 05 2003 3 Increase the depreciation value and tax value by 1 00 to force the software to ask if you would like to freeze the asset for both Book and Tax 4 Select Yes to freeze the asset o Edit the asset again and change the depreciation and tax values figures back to the original figures Also change the Date Book and Date Tax to begin back to 02 05 2003 and save the record 6 Select No to freeze the asset again Roll the period to 31 05 2003 view the update asset screen and the program will now calculate 30 days depreciation for the asset with prior year depreciation 64 Q17 17 018 A18 Q19 A19 If depreciation for a particular period is already processed can it be unp
42. e at which the asset becomes available for use again 46 Cost The cost of maintenance is divided up into Labour Cost and Part Cost Maximum amount 99 999 999 99 Maximum length 10 digits Service Company Details Maximum length 20 characters Maximum length 10 alphanumeric characters Contact Person contact person at the Service Company Maximum length 30 characters Telephone contact person s telephone number Repair Status The repair status can either be good or fair In either case there may still be a need for further repairs click on the check box if this is so Comments Any comment regarding the repairs made should be keyed in here Maximum length 200 characters Maintenance Reports Report Filter Maintenance Report Company Code ACROH ACROH IHBUSTRIES Report Heading Report utilisation Report TTPIPITTTITITTTITITITITITITTITITITETIITIIITITITITITITITIITITIITITIETITITETITIITITTITITITITITTITTTITITITITITITITITITITITIIIIE Haintenance Cost Summar Two reports are generated out of data provided in the Maintenance History screen These reports are Utilisation Report The Utilisation Report provides an analysis of assets that have been sent for maintenance in terms of availability taking into account downtime and operating time Maintenance Cost Summary The Maintenance Cost Summary summarises the costs incurred in maintaining the assets Details are stored in the Maintenan
43. e to a new asset code 2 one code to another within the same company eg an asset can be transferred from Dept1 to Dept 2 within Company A 3 one combination of codes to another on a specified date In the case of a partial transfer the number of units to be transferred is specified and the relevant cost and depreciation amounts are then carried to the transferred asset Exercise 8 Use the information below to transfer asset Number 0000000005 Asset Code 0000000005 Clay Department Units to transfer 1 Transfer Date 22 08 99 TRANSFER AN ASSET Asset Details Company Code ACRON ACRUH THDUSTRIES Asset Code we age HONDA S2B8B Serial Mn Ma af Units Asset Department Cast Centre Location New Asset Details Asset Code Department CostCentre Location Units to Transter Transfer Date Description of Transfer TRANSFER OF 32866 TO SALES 25 The original transferred asset record will be retained in the assets list as an inactive record until the next End of year routine is run at which time all inactive asset records are deleted If you generate a Depreciation Report you will see that Total Depreciation up until the transfer date can be seen The I indicates that the asset has been transferred in BOOK DEPRECIATION f cccccccccccccccccccczczczc 2 2 CATSOFT ASSETS Report DEPRECIATION F
44. ears year period freeze depreciation begin 1 100x 01 07 97 01 07 99 100 000 00 10 000 00 21311 48 1311 48 0 00 68688 52 1 200 01 07 97 01 07 99 100 000 00 10 000 00 1311 48 1311 48 10000 00 88688 52 NB Asset number 1 100 which has not had prior years depreciation frozen shows depreciation in the this year and the this period column which is an incorrect figure Asset number 1 200 has had the 10 000 prior years depreciation frozen Column Eight and one months depreciation has been calculated correct from the date book to begin Notice the difference in the depreciation dates to begin asset number 1 200 begins depreciation from the date at which the freeze takes place 16 Unfreez ng Assets Effects of Unfreezing an Asset e fthe asset has not been frozen before there will be no effect e asset had been frozen before and is unfrozen once 1 The At Freeze column Book Tax will be set to the previous freeze amounts 2 The Date Book Tax to Begin will be set back to the previous freeze dates e fthe asset had been frozen before and is unfrozen for the second time 1 The At Freeze column Book Tax will be reset to 0 00 2 he Date Book Tax to Begin will be replaced with the Purchase Date Note If you want Catsoft Assets to recalculate depreciation from the Purchase Date you have to set the At Freeze column back to zero You do so by running the Unfreeze routine twice Normal Operation At thi
45. een 2 Click on SEARCH for the asset you wish to clone 3 Click on the CLONE button and change the code of the asset 71 Q34 A34 Q35 A395 Q36 A36 Q37 A37 Q38 A38 Q39 A39 Our accounting month is on a 4 4 5 week basis Can this be set up accordingly for depreciation calculation Catsoft Assets calculates depreciation on a daily basis Hence it is possible to calculate depreciation for a particular period for instance 14 days 2 weeks or even 12 weeks 3 months How can you assign an asset to a person You can enter the custodian s details in the SUPPLIER section and or SERIAL NUMBER field Both have a maximum length of 20 alphanumeric characters and are located under the ADD REVIEW ASSETS The details can be generated under the Purchase Report What is the Export Journal Entry Data Report The Export Journal Entry Data Report displays book depreciation for the period in journal format and can be saved as a text file like the other reports including the Tax Depreciation report The Export Journal Entry Data Report however is different in that it is designed to be opened as a delimited text file in Excel or Lotus 123 The user sets up account numbers representing each GL expense account against either department code or the cost centre code and GL provision account against each Asset Type The net effect is a comprehensive depreciation journal entry which can be exported out as a text file C
46. en down value at the end of the current period its location and current department and cost centre This reporting structure is invaluable in determining the current status quo of all the assets and the replacement asset requirements for the future tme ent Pri Ual Ual nt re ice ue ue Clear All Process 36 Disposal Report From the main menu bar select Reports Tracking Reports then Disposals Report The user can choose to display both the fully and partially disposed assets book or tax figures and insert page breaks at the end of each Asset Type The difference between this report and the existing standard set of Disposal Reports is that it reports on disposals stored in a separate file maintained independently from the existing depreciation engine and kept separately from the existing disposals audit file This file is not cleared at the end of the financial year unlike the existing disposals audit file hence lengthening the coverage of disposals reporting indefinitely Therefore from installation of 4 04 onwards the current year s disposals and all ClearAll Process subsequent disposals will be stored indefinitely and made available to the tracker disposals report providing users with a complete picture of every disposal made since The report displays an asset s last location before disposal its disposal date proceeds on disposal its book or tax written down value on disposal its boo
47. ent Code DEPT Company Code 99A Description Department 1 Depreciation Account Number First Prior Next Search Edit Add Clone Del Help Quit Cost Centre ES Costcentre Code 51H71 Company Code 99A Description Cost Centre Depreciation Account Number DEPR CCTR 48 Location X Location Code 061 Company Code 996 Description Location 1 Location Barcode pooo First Prior Next Last Edit Add Clone Del Note that the Department Cost Centre and Location fields allow character entry of up to thirty characters for descriptive details Account codes can be up to twelve characters in length Default depreciation methods are entered into the asset type screen see below This saves the user from having to re input depreciation rates and methods for the same class of assets If different rates are required to be entered for individual asset items these can be entered in the Overriding depreciation rate method fields in the main update asset entry screen see following page Asset Types Asset IMHWURI Company Code 99A Description Immediate Write OFF Demo DEPRECIATION METHOD Book Basis SU book 5 08 if S or R Units of Usage if U Tax Basis SR Tax Depre ifS or A GENERAL LEDGER ACCOUNT NUMBER Asset 55 Provision for Depre REVALUATION INDICES Revaluation Index 1 0000 if no change
48. eriod the filename could be NOV2002 ZIP so the entry of C WNOV2002 ZIP will create NOV2002 ZIP in your C drive 6 Under Options tick Save full path info 7 Click on Add 8 Once complete close the Winzip to exit The backup ZIP file is now on your drive If the file is small enough you could copy it into a standard 3 5 1 44Mb floppy disk 9 At a later stage if you do need to restore the data exit the program then run Windows Explorer again 10 Simply double click on the ZIP file and press the Extract icon 11 Navigate to the drive and folder you need to extract to click on the Extract button When prompted to overwrite existing files click on Yes to all 12 Once complete close the Winzip to exit Then check that the data is correct before re commencing your transaction entries Note if you encounter a problem that requires Catsoft Support assistance you could attach the ZIP file of your data created using the steps above to an email Address the email to catsoft tpg com au and provide details on the problem We will prescribe a solution to you based on the information we obtain 58 Q4 A4 Q5 A5 How to install zipped data DATA zip into Catsoft Assets As an example we will need to unzip the back up data into a specific location e g H Catsoft assets40 Backup To do this 1 Go to Windows Explorer select and double click on the Data zip file 2 A WinZip window will then appear Click o
49. es At this point it is necessary to group assets into types in order to apply depreciation rates This part of the form is useful for applying the same depreciation rate to a large group of assets in the same category for instance a company may have 100 computer terminals To apply depreciation at the same rate across all of the computers the rate need only be applied once Asset type forms can also be set up with zero depreciation rates for assets which Will not have depreciation applied To enter the Asset Type screen go to the File menu and select Asset Type Alternatively click on the Asset Type icon Click here Asset Types Asset Hu Company Code Descrption HOTOR VEHICLE DEPRECIATION METHOD Book Basis SPU book Depre Units of Usage if U Tax Basis SF Depre if 5 or A GENEHAL LEDGER ACCOUNT NUMBEH Asset ASS COST TYP Provision for Depre PROU DEP TYP HEVALUATION INDICES Hevaluation Index 1 0000 if no change Insurance Index 1 0000 if no change Edit Add Clone Del 12 MS Exercise 3 Type in the following details into the above screen Asset type Motor Vehicles Straight Line Book Depreciation Straight Line Tax Depreciation Input of company assets To enter in a new asset go to File and select Asset Alternatively click on the Update Asset icon Update Assets Company Co
50. et entry screen has a field titled Units which allows the user to enter a number of units up to 999 that comprise the asset record item Assets with two or more units can be partially transferred or disposed as required allowing considerable flexibility An item that was entered as a single unit could easily be split into two or more units if the user wanted to achieve such a result as for example sharing depreciation charges for a single item such as leasehold improvements to a building across two cost centres b Scanner to be pre programmed with asset listing for a particular location This option is not available in Catsoft Assets Once again we would suggest potentially carrying a notebook PC on site and running an exception report from the bar code reader on site c Data input to be via a form with drop down boxes As the entry screen depicted earlier indicates this feature is standard in Catsoft Assets d Password controlled access for deletion of assets etc There is a five level hierarchy security access feature to Catsoft Assets Levels range from level one which allows the user to lookup data only and not add modify or delete records through intermediate levels which allow for example the entry or modification of records but disallow the deletion of records to the full level five access which allows the user to access all functionality within the package including the ability to allocate other user names and pa
51. fected the method and or rate can be changed at the Asset Type level When the record is saved the user will be prompted with the freeze question Note if the asset is to be written off immediately choose the depreciation method as for immediate write off and leave the depreciation rate blank Incorrect Disposal Transaction If the user enters a disposal transaction with an incorrect disposal date and saves the transaction the user will be unable to undo that disposal Once a disposal transaction has been processed the record is locked away for audit trail purposes and becomes inaccessible to the user except through reports As such disposal details cannot be altered Therefore the user has only two options Either restore a backup taken prior to the disposal and enter the transaction again with the correct details or Enter a new asset with similar asset details dispose this new asset with the disposal details In the reports the disposed asset will appear twice to which the user has to insert a note to clarify the matter A message appears warning of the existence of post dated transactions when the End of Year routine is attempted The error appears when the user attempts to close the year but transactions have been entered after the current period s end date The transactions in this case refer to disposal revaluation or transfer Catsoft Assets version 4 04 and Assetlite 1 09 allow users to proceed past this point a
52. hase Date This year and this period dates inconsistent The company s dates should be consistent Thisyea i Pis oe en source ari companies are between the source and the destination inconsistent Please ensure consistency companies Where the dates are inconsistent these dates before trying again an error message will appear The depreciation amounts are consistent with a particular set of dates Therefore to maintain parity between stored depreciation figures and company dates it is imperative that the dates of both companies are consistent Once this condition is fulfilled the move is allowed and the user is then be able to access the relocated assets by selecting the company they were moved to MOVE ASSETS source Company CRATL Destination Company CETA This period l l1 z n0 30 06 2000 This year O1 01 2000 30 06 2000 Asset ID Description Dept CCtr Locn Purch Date 0000000001 000 computers ADMIN NORTH 0170171999 0000000002 000 Chairs JUUTH 01 01 2000 lf none of the structural codes exist in the targeted company i e department asset type cost centre and location codes these are copied automatically when the move is made After the move a report will confirm whether the move has been successful Page two onwards will display a list of all the asset s moved 29 Revaluation by Indices Revaluation by Indices allows the revaluation of a class of asset
53. int labels at that time if required Catsoft Assets has a bulk transfer function that allows the assets of an entire department cost centre location or combination of the above three categories to be transferred all at once in a one touch operation A variety of different assets can also be transferred whether in part or full using our individual asset transfer function see below 52 TRANSFER AN ASSET Asset Details Company Code 99fh Catsoft Demo Asset Code TeSt Asset Form Commodore serial No No of Units Asset Type Department CostCentre Location New Asset Details Asset Code Department CostCentre Location Units to Transfer Transfer Date Description of Transfer Transfer reports will give details of the nature of the transfer Labels detailing the new asset allocation can be printed at any time 8 Manual re adjustment deletion of entries As the update asset entry screen depicted earlier shows the user can edit delete clone or add new asset items at any time Any details can be adjusted as required and where the change relates to depreciation information for an asset with accumulated depreciation the user is given the option of freezing depreciation details in effect locking n previously calculated depreciation or making changes retrospective Other Features a Ability to store a quantity of identical items The update ass
54. ion Catsoft Assets will automatically ask you if you wish to freeze the asset Click on Yes I will explain later why we do this 14 4 Exercise 4 Enter in Each of the following Assets Sub asset code Description Number of units Asset type Department Cost centre Location Purchase date Deemed date Date book to begin Date tax to begin Purchase price Deemed value Depreciation value Taxation value Section 57AF Book Prior Years Tax Prior Years 0000000001 000 Toyota Rav 4 1 Motor vehicles Sales Northern Clayton 30 05 99 30 05 99 30 05 99 30 05 99 26700 26700 26700 26700 No 350 400 0000000002 OOO Honda CRV 2 Motor vehicles Sales Northern Malvern 01 03 1997 01 03 1997 01 03 1997 01 03 1997 88000 88000 88000 88000 No 18000 14500 0000000003 OOO Honda Civic 1 Motor vehicles Administration Southern City 01 02 1998 01 02 1998 01 02 1998 01 02 1998 40000 40000 40000 30000 Yes 10000 12000 00000000004 000 Volks Wagon New Beatle 1 Motor vehicles Sales Southern Clayton 01 02 2000 01 02 2000 01 02 2000 01 02 2000 60000 60000 60000 60000 No 0 0 00000000005 000 Honda 52000 1 Motor vehicles Administration Eastern Malvern 01 03 1999 01 03 1999 01 03 1999 01 03 1999 75000 75000 75000 75000 No 1000 1000 15 0000000006 000 BMW Z3 1 Motor vehicles Sales Eastern Clayton 01 03 1998 01
55. k or tax profit or loss on disposal and its Capital Gain or Loss on disposal The accumulated depreciation and the written down value of the asset used to calculate the profit loss and capital gain loss figures in the tracking report can be ascertained by running a standard depreciation report for the same period oF Help on the ES how to use the Quick new report Reports facility existing i Quick report current report Save the d Print Preview report Print current Save the bel current report Exit the Quick under a Reports different ili facility name The Quick Reports facility allows the user to create customised reports reports that do not already exist in Catsoft Assets Quick Reports uses the drag and drop technique and hence the presence of a mouse is necessary The following is a standard procedure on how to create quick reports click indicates pressing on the left mouse button unless otherwise specified 1 Decide on the report you want Click the mouse on File and either select New for a new report OR Open for an existing report if you had previously created any Double click on the report you are after To select highlight then either double click here or Select Database Each report that you create refers to a particular DBF file No single report can refer to more th
56. n not roll back Please note that when it prompts you to PACK FILES select NO Scenario Client currently has the program at 30 06 2004 and he comes to the end of period i e end of July Should he roll to the END OF PERIOD July and click on END OF YEAR Or should he just click on END OF YEAR without rolling to the END OF PERIOD because the software is already at the end of the year 30 06 2004 If it has already been rolled to the end of the financial year then you can just click on END OF YEAR For example if your financial year is 01 07 2003 30 06 2004 then your year period end date is 30 06 2004 Can roll back to my last financial year from 30 06 2003 to 30 06 2002 You can not roll back to your last financial year Should not close off 2002 2003 financial year before roll back to 30 06 2002 Do not close off 2002 2003 yet i e 30 06 2003 if you would still like to roll back to 30 06 2002 More importantly take a back up of the data before you close off 2002 2003 as a precaution Will the opening written down value on 01 07 2002 be the closing written down value which froze on the 30 06 2002 Freezing the asset will lock away accumulated depreciation Prior Years This Year at the date of freeze to ensure that the new rate will only apply from the date of freeze onwards and not in retrospect For example where the asset is frozen as at 30 06 2002 the new rate will apply from 01 07 2002
57. n the Extract button 3 In the Extract to field type in H Catsoft assets40 Backup After that click on the Extract button 4 When the extraction has been completed go to Catsoft Assets Program click on Utilities Change Data Path 5 In the field titled Path type in H Catsoft assets40 Backup After that click on the Ok button 6 A Catsoft Assets start up screen will then appear Type in the Username and password What happens when an asset is frozen When an asset is frozen the date book tax to begin changes to the beginning of the next period The depreciation to date i e Prior Years plus any amount in This Year is added together and copied into the freeze column replacing any existing freeze amount Subsequently the program recognises that the asset had a certain amount of depreciation reflected in the freeze column on a certain date represented by the date book tax to begin n this way the program ignores how that portion of depreciation was arrived at and focuses solely on calculating depreciation from the date book tax to begin onwards based on the depreciation method and rate specified Example if an asset is frozen while the current period end was 30 06 2002 the date book tax to begin changes to 01 07 2002 Depreciation up to the 30 06 2002 let us say 2800 is inserted into the freeze column replacing the existing freeze amount In subsequent periods this entry is interpreted as having 2800 worth of depre
58. nd complete the End of Year routine The audit files will still be cleared including the post dated transactions These versions are now available to download from our website www catsoft tpg com au Download section It takes a long time to process any report To resolve the problem we need to adjust the setting that is attached to the Shortcut of the Program We need to apply UTD Use Temporary Directory in the Shortcut to the Program so that the data will be copied temporarily to the local drive to speed up the processing of reports To do that Right click on the Catsoft Assets Program Icon and select Properties Inthe Target field of the Shortcut section add in a space and UTD at the end of the Target e g X Catsoft ASSET40 ASSETWIN EXE UTD 61 Q11 A11 Q12 A12 Q13 A13 014 14 How to forecast depreciation for all assets for next 5 years Catsoft Assets has the ability to provide users with a depreciation forecast report for all assets for a period up to 5 years This is done by selecting Reports Depreciation Forecasting and specifying the date range a user wishes to forecast The report will provide a breakdown of depreciation charges for each asset by each month over the specified period of time An error message Invalid Depreciation Value or Invalid Tax Value appeared This error usually occurs when a user is attempting to edit the details of a particular asset To resolve the si
59. nd method used for each individual asset with its depreciation charges forecasted for each month right up to the end date specified You can either send the report to the screen or save it as an ASCII file The ASCII text file should have an extension of TXT or DAT This file can then be opened in a spreadsheet application such as Microsoft Excel as a delimited file and worked upon or saved as a normal spreadsheet New Export Journal Entry Data Feature Additional selection criteria have been added to the existing Export Journal Entry Data based on comparisons between department cost centre or asset type categories Where a specific combination has gt been selected the system will total the depreciation for the two categories and generate a report with its suggested ledger entries Select an Export Journal Data Report as you normally would Then in the Report Type section select the combination required You can print the report to screen or printer and manually transpose the data into your general ledger Alternatively you can save the report to disk and open as a delimited text file in a spreadsheet The report created is in a comma delimited format and it shows the accounts with its appropriate amounts For the convenience of user of both Attach Business Partners and Attach Catapult a conversion utility has been developed to facilitate the transfer of journal data to these applications Other Features e Assets
60. ny s structure consists of Departments Cost Centres and Locations Every company must have at least one department and one cost centre but it is not mandatory for it to have locations Exercise 2 Setting a Department Go to the File menu and choose Department or alternatively click on the Department icon Click here Department Company Code Department Code Description ADMINISTRATION Depreciation Account Number JDEFR DEPF T First Prior Next Search Edit Add Clone Det Help Enter the following details Department Code ADMIN SALES SERV Description 1 Administration Sales Marketing Setting up a Cost Centre Go to the File menu and select Cost Centre or alternatively click on the Cost Centre icon Click here Cost Centre Costcentre Code Company Code Description jEASTERN REGION Depreciation Account Number DEPR CCTR Enter the following details Cost Centre Code EAST NORTH SOUTH Eastern Region Northern Region Southern Region Setting up a Location Setting up a location is optional To do so go to the File menu and choose Location Alternatively click on the Location icon Click here Location Location Code Company Code Description 51 15 Location Barcode The Location data field is an optional set up Location Code CLAY CITY Clayton 11 Establishing Asset Typ
61. ode The Sub Asset Code must have a maximum length of 3 alphanumeric characters For example the original asset is BL0001 001 An extension to that asset would be 0001 002 We recommend this method as it is easier to keep track of any extension made to an asset 66 Book Value Updated Book Value Written down value at any given time to be available in respect of the following Each individual asset The Book WDV is available at any given point in time through the Update screen of each class of asset to agree with the ledger To obtain the Book WDV for a class of asset user can run a depreciation report or a book journal report Total of all assets to agree with the ledger To obtain the Book WDV for all assets user can run a depreciation report or a book journal report Taxation Capital allowance rate The depreciation rate of the asset can be set in the asset type and when select the asset type for the asset the tax rate will be transferred across and will become a default rate If users wish to vary the depreciation rate the user can do so by filling out the overriding rate for the asset Details of total capital allowances claimed at a given date The tax depreciation for the asset at a given date is available through the Update screen Tax written down value The tax written down value can be found in the Update screen Tax profit loss on disposal When the asset is disposed the gain loss from dispos
62. ompany X would like to create a Parent Child relationship within Catsoft Assets and would like to be able to report on this This can be achieved through the use of the sub asset code Each asset record must have a unique identifier which is a combination of the ten character main asset code and a three character extension known as the sub asset code This means the user can retain the same asset code and insert a different sub asset code for each sub asset The relationship will be reflected in reports when assets are sorted by asset code Before rebuild the indexes how can get the original report 30 June 2003 that was backed up To get the original report as at 30 June 2003 you will need to ensure that the data path selected under UTILITES CHANGE DATA PATH is correct before you rebuild the index When we revalue assets the system only revalues the book value and not the Tax value Is there a way that the Tax value can be altered as well As asset revaluations are not recognised under the current tax law an asset revaluation will not change its tax value However the user can edit the asset record and manually later Tax value and Prior Years deprecation directly 72 Q40 40 Q41 41 042 42 043 A43 What is the process of rolling over into a new financial year Below are the following procedures 1 Roll to the END OF PERIOD 2 Create a BACKUP because once the YEAR END has been closed you ca
63. onwards i e the asset s written down value at that date closing WDV as at 30 06 2002 opening WDV as at 01 07 2002 If the asset was NOT frozen the new rate would have applied in retrospect i e if the asset s Date Book to Begin was 01 07 2001 the new rate would apply from that date causing the software to recognise a discrepancy between the depreciation to date based on the new rate and recorded depreciation to date based on the old rate and add it to current year depreciation the This Year column 73 Q44 AAA Q45 A45 Q46 A46 Q47 AAT Q48 A48 Q49 49 If client have processed couple of End of Periods and are now in the month of October All financials have been completed for the month of September If client forgot to add in an asset that they want to depreciate since June is there any way that all depreciation be allocated to the current period instead of spreading through and therefore throwing the accounts out The This Year figure for the asset in question is the adjustment This information can be obtained from a standard Book Depreciation Report Once client has decided to go with Catsoft is there a way in downloading the information as opposed to manually entering these in Yes there is assuming the information is stored or can be exported into a spreadsheet A data conversion or import is then possible at a fee that is quoted based on the information provided to Catsoft via e
64. own tax value but less than its original cost Go through the same process we used earlier but this time dispose of Asset number 0000000003 Enter in the following details Selling Price 30000 Dispose Date 02 09 99 and then dispose of the asset We will now enter in the new asset details that you are going to apply the balancing charge to via the Update Assets screen Asset number 0000000008 Date book to begin 15 09 99 Sub asset code 000 Date tax to begin 15 09 99 Description Company code Asset type Department Cost Centre Location Purchase date Book prior years 0 Deemed date Tax prior years After completing this click on the Balancing Charges icon from the Routines menu xem Assets Yersion 4 Utilitie ale j Entry Screens Routines 4 Reports Utilities Routines Reports 23 In the Balancing Charge routine screen below select the disposed asset 0000000003 and the asset you wish to apply the balancing charge to 00000000068 BALANCING CHARGE Disposed Asset Company Code THDUSTRIES Asset Code Selling Date 92 69 1999 Description of Dis DISPOSAL OF HONDA CIVIC Tax Profit 5549 18 Available B 88 Balancing Charge Details Please create replacement asset s first Asset sub Tax Value Max Applied Amt Applied Disposed Asset The asset we are B8BBB 5549 18 5549 18
65. preciation window and click on the OK button When the unfreeze process is completed the program will indicate how many assets have been unfrozen Freeze the assets again by selecting Routines freeze Depreciation as outlined above After that roll the period forward to the current period Exit the program go to windows explorer and select C catsoft assets40 data Delete the blank DISPOS A DBF and REVAL AU DBF files and rename the DISPOS A BAK and REVAL AU BAK back into DISPOS A DBF and REVAL AU DBF respectively Then go back to Catsoft Assets Program and rebuild the index by selecting Utilities Rebuild Index Close the Catsoft Assets program and re enter the Program again Run the depreciation report and check to see if the depreciation for all the assets is calculated correctly 63 Q15 A15 Q16 A16 An Error message Assetlite Line 559 Error appears Assumptions The data path is C catsoft Assets40 Backup This situation usually occurs when a user has previously taken a back up of the data using CD Rom and is now unable to open the back up files in Catsoft Assets generating an error message Assetlite Line 559 Error To resolve the situation go to Window Explorer select C catsoft Assets40 Backup Select all the files within the Backup folder right click on the files and select Properties A Property window will appear untick the Read Only option in the Attributes section An error message Dat
66. r time last scanned do not match and any other pertinent information including allocative details written down value purchase price etc can be included in the report as desired by the user 3 List assets correctly located at a location following a scan Catsoft Assets generates scan reports to indicate assets scanned during an audit and exception reports to show where discrepancies have arisen The software does not generate a report of assets that are correctly located within a particular location although the same information could be gleaned from running a scan report and exception report with the report filter control set to limit the report range to the desired location 4 List assets above or below a selected purchase value or written down value Our normal depreciation reports which also serve as an asset listing for most purposes can be filtered to limit reporting to assets above below or between a particular depreciation value depreciation value being the value from which depreciation calculations take place and unless specifically altered by the user is identical to the purchase price Additional asset listing reports with filtering based on the specific purchase price or written down value can be easily generated using the Quick Reports custom report writer 5 Generate suggested disposal list based on depreciation criteria We would suggest that in order to generate such a report the user run a depreciation repo
67. r this individual vehicle by clicking on Edit Overriding Book Overriding Tax NB REMEMBER TO FREEZE THE ASSETS AFTER CHANGING THE DEPRECIATION VALUES 21 Disposal of an Asset To dispose of an asset go to Update Asset items in the Routines menu and choose Disposal or simply click on the Disposal icon Click here Partial Disposal This routine allows you to dispose of units of an asset For an example we will now dispose of one unit of asset 0000000002 ie one Honda CRV DISPOSE OF AN ASSET Asset Details Company Code ACROH ACKOH IHDUSTRIES At a specified Ls aeu HONDA CRU amount Selling No of Units Price Type HU MOTOR VEHICLE Department SALES SALES MARKETING Cost CenNe NORTH HORTHERH REGION One eek Location PAL MALUERH date Disposal Date serial Mo Purchask Value Deemed Value 88 088 80 Depr Start 5 N6 1999 Deemed Date 91 03 1997 Selling Price Expenses 40 008 68 dip 81 88 1999 Units Disposed Disposal of one Honda CRU The number of units to be disposed Dispose Date Description of Disposal The d in this report indicates the partial disposal of the asset Report DEPRECIATION FOR JULY 199 BOOK lt CATSOFT ASSETS IN ASSET CODE ORDER This period Thu 01 07 1999 Sat 31
68. re Data facility The Users option is also unavailable on this level Level 2 Level 2 users can view clone and add to Data Entry Screens Users on this level can access the Update Asset Items option under Routines Cycle End Freeze Unfreeze and Deletions are not accessible Under Utilities the Import Utility if applicable the Backup Restore Data facility and Users like in Level 1 are not accessible Level 3 Level 3 access includes viewing cloning adding and editing Data Entry Screens Users in this level can access all options under Routines except Deletions Under Utilities the Import Utility if applicable the Backup Restore Data facility and Users are not accessible Level 4 Level 4 users have full access to the Data Entry Screens i e including deleting a record All other options are also available except Deletions and the Users option Level 5 Highest Level Level 5 is the highest level of security and as such full access to all screens in Catsoft Assets 4 including the Users option under Utilities Hence only users with Level 5 can add alter or delete user names and passwords Level 1 Level 2 Level 3 Level 4 Level 5 Data Entry Screens Routines Update Asset Items e Cycle End e Freeze Depreciation e Unfreeze Depreciation e Deletions Reports Utilities e Export e Import if applicable e Users e Rebuild Index e Backup Restore Data e Change Data Path Maintenance Barcode Legend
69. rocessed In Catsoft Assets you can roll the period back using the End of Period routine but you cannot go past the end of the last financial year This is useful for making changes to depreciation rates then rolling the period forward again in order for depreciation to be recalculated However rolling the period back does not undo disposals transfers or revaluations Once the period has been set to a previous period via the End of Period routine the user can re run reports The reports may need to be reconciled against subsequent events such as acquisitions disposals transfers and revaluations that have occurred in a subsequent period This is due to the same reason stated above i e rolling the period back does not undo these transactions Can the system forward process depreciation Yes through the process of rolling forward or using the depreciation forecast This specific forecasting facility under reports allows the user to forecast depreciation for up to five years in a delimited file format compatible with spreadsheet applications such as MS Excel and Lotus 1 2 3 Please provide the list of main asset fields in the Catsoft Assets program Assets e Date of purchase In Catsoft Assets you enter the asset s date of purchase in Purchase Date field in the Update screen e Details of the supplier The name of the supplier of the asset should be entered under the section of Supplier This field is optional via the Update
70. rred to does not exist then Catsoft Assets will ask you whether you want to create the new path and whether you would like it to create the necessary database files If you answer yes to both questions the new data path will be created ready for you to set up your new database 45 Maintenance History As the title suggests this screen displays details pertaining to any repairs or routine maintenance made on a specified asset Maintenance Company Code ACRON Asset Code Date of Service 11 12 1999 Date Returned 18 12 1999 Labour Cost Part Cost 2000 00 Total Cost 3600 86 Service Company 5 1 5 Repairs Invoice 86811852 Contact Person Telephone 103 9553 2188 Hepair Status Comment Not a very good job Parts were second hand Hence we recommend that an alternative be selected the next time we The search key for maintenance data is the Asset Code Date of Service Navigation on this screen is similar to that described in Chapter 4 Entry Screens Asset Code The Asset Code that you key in must belong to an existing asset Hit F7 or click on amp to bring up a list of active assets Maximum length 10 alphanumeric characters The sub asset code is the additional box to the right of this field Maximum length 3 alphanumeric characters Date of Service This is the date at which the asset become unavailable due to repairs Date Returned The dat
71. rt and utilise the filtering options for purchase date to short list assets for disposal For example computer equipment purchased prior to 1996 Alternatively the user could make use of our custom report writer to select assets with any of a number of criteria that would recommend them for disposal for example motor vehicles with a written down value of less than 12000 or motor vehicles with a written down value of less than 20000 that were purchased for greater than 35000 The maintenance reports produced by Catsoft are also useful for targeting assets for disposal as they record service visits and parts and labour costs for individual asset items that have required repairs As such items that are becoming costly to maintain can be quickly isolated using this reporting function 6 List acquisitions or disposals during a defined period Details of purchases transfers and disposals are stored for all assets in the database for the duration of the current year and can be further filtered according to asset type department date of acquisition disposal etc as required Note that when the user closes off the year these details are deleted from the current year database but if the database is copied to a backup directory prior to running the year end previous years acquisition and disposal details are still readily available 7 Handle a batch transfer of assets from one location to another and adjust asset listing at each accordingly and pr
72. rt can be run and the report can be sort by purchase date List of disposals during the year A disposal report can be run Asset wise breakdown giving the details of profit loss on disposal This can be obtained through running a disposal report List of assets purchased disposed during a given period This list can be obtained through running a purchase report to give a list of assets purchased and a disposal report can be run to give a list of assets disposed during a given period Disposals Date of disposal When disposed of an asset the user needs to enter a disposal date and the software will calculate the depreciation for the asset up to the dispose date The disposal date of the asset will be displayed in the disposal report Sale price and the details of profit loss on disposal When the disposal routine is selected the user has the option to enter in the selling price of the asset when disposed Once the disposal has been done in the disposal report it will show any gains loss made from the disposal Incorporation of any additional costs relating to the disposal in the above calculation When the disposal routine is done the user has the option to input any expenses incurred when disposing the asset and this amount will also be taken into account in calculating any gains loss from sale of the asset 68 Q21 A21 Q22 A22 What are the additional software capabilities of the Catsoft Assets software Forecas
73. ry fields Company Department Cost Centre and Asset Type Can you transfer assets between companies and if so what profile stays in the old company and what moves to the new company You can use the TRANSFER function in that no trace of the asset stays with the source in this case the old company Effectively the entire asset record and its depreciation history moves to the new company A detailed report is generated displaying the number of records processed company structure fields generated where absent in the target company and a list of the assets moved What happens if there is an error in the import eg a field is not set up but in the import file A status report and or detailed error report if errors occur is generated at the end of the import The user is given the line number of the record with the error and at the end of the report the number of valid importable records out of the total number of records Is there any liability to transfer a leased asset to an asset in Catsoft when the residual is paid out There is none The user must key the asset directly into Catsoft Assets as the two databases are structured differently Can you give me a rundown on the security profiles in Catsoft Assets There are five security profiles that can be selected when setting up a user Level five grants full access to all screens while level one only allows viewing of selected entry screens Can construction in process items
74. s Internet P L button will mark select all companies for backing up Clicking on this button will unmark unselect all companies for backing up To proceed click on OK or to abort click on Cancel Only records belonging to the selected company are backed up compressed into one file with the company code as the filename and an extension of CMP e g if company TF was selected the filename will be TF CMP If more than one company is selected then more than one CMP file will be created ex Restore Data ftom Disk If the file or files you wish to restore were backed up using the Backup facility above then you can use this Restore facility The designated drives should either Restore Data be A or B If C is designated then the backup file from the root directorv will be restored 42 Once a drive is selected the following window will appear displaying the codes for all existing companies from which you can make a selection for restoring To select the company click on the check box Clicking on this button will mark select all companies for restoring Click on this button to unmark unselect all companies To proceed click on OK or to abort click on Cancel Only records belonging to the selected company will be restored these records will be copied into the relevant database files overwriting existing records V Restore only works on Back
75. s and cost centre codes Importing Exporting Data Catsoft Assets has a specific Export function as well as having a Quick Report facility that allows the user to design reports for each database file separately hence allowing the user to select fields and filter the output according to requirements The Import facility is a separately purchasable module allowing the user to import acquisitions directly into the database Updates of current tax laws The flexibility in built into Catsoft Assets structure allows for pooling of assets Can all reports generated be exported to spreadsheets with titles and format in order Yes Catsoft Assets has a specific Export function as well as having a Quick Report facility that allows the user to design reports for each database file separately hence allowing the user to select fields and filter the output according to requirements 69 Q23 A23 024 24 Q25 A25 Q26 A26 Q27 27 028 A28 Q29 A29 Can and how do we run multi companies It is possible to run multi companies To set up new companies all you need to do is go to File Company and press Add to put in new entries To work on a particular company go to File Setup Company choose the company that is to be worked on and this will bring up all the relevant data of the company In Catsoft Assets when setting up an asset what fields are mandatory Each asset requires the following mandato
76. s or an individual asset by a fixed percentage i Exercise 9 Enter the Asset Type screen via the Entry Screens toolbar Select the Asset Type you wish to revalue in this case we shall revalue Motor Vehicle Click on Edit to change the Revaluation Indices details to Revaluation Index Asset Types Asset Type Mu Company Code Description DEPRECIATION METHOD Book Basis 5 10 book Depre if 5 or R Units of Usage itU Tax Basis SR Tax Depre GENERAL LEDGER ACCOUNT NUMBER Asset ASS COST TYP Provision for Depre PROU DEP TYP REVALUATION INDICES Revaluation Index 1 0000 if Insurance Index 1 0000 if This will increase all depreciation values on asset types by 8 and all insurance values by 5 30 Once the index amounts have been changed it is then a matter of processing the change to update the assets new values From the Routines menu select Update Asset Items and then Revaluation by Indices Specific assets can be selected for revaluation based on the ranges that you set up in this filter screen Revaluation by Indices Depreciation Value Company Code ACRON From Ta asset cose el T Depreciation Value Select the value you want the indices to be based upon by clicking on the relevant leaf or using Alt D Alt W or Alt I Select the Asset Code 0000000006 and then click on OK This will revalue the asset up by 8 and the ac
77. s stage it is possible to commence operations Normally a Period End is run at the end of every month which will calculate a months depreciation on every asset At the end of every financial year a Year End is to be done Prior to doing a year end ensure that a backup is made of the data It is also advisable to backup data at the end of each month week or even each day depending on the magnitude of work done in Catsoft Assets i Exercise 5 Go to the Routines menu and select Cycle End and then End of Period or simply click on the End of Period icon Click here Roll the period end date forward a month by entering in the end date as the 31 07 99 This will calculate depreciation to the 31 07 99 and the next period s depreciation will be calculated from the 01 08 99 Consequently check to ensure depreciation has been calculated correctly END OF PERIOD Depreciation on assets will be calculated for the period from the previous end of period run to the current period end date he period end date need not be a month end date Company code ACROH INDUSTRIES This period dates Book value to Tax value to Enter one or both of the dates to specify the desired calculations Next period dates Book value to 31 97 1999 E Tax value to 3140771999 ma X Cancel Help Report Filter Depreciation Report Company Code ACROM INDUSTRIES Report Heading DEPRECIATION FOR JULY 1999 Report
78. s the depreciation between the last end of period run 31 07 99 and the transfer date 22 08 99 26 When a period end is run after the asset has been transferred the depreciation in the Transferred In asset will show depreciation from the transfer date 22 08 99 to the end of the period 31 08 99 BOOK DEPRECIATION CATSOFT ASSETS Thus period Sum 01 09 1999 Tue 3170571999 Thus year Tim 01 07 1999 Tue 31703 1999 Company ACROH INDUSTRIES Fun date O1 03 2000 Page 1 ASSBTCODE DESCRIPTIONS EF R BC LA TION CLOSING PUR DATE DEFF BEGIN DBFR YALUE OFENING WOY PRIOR YEARS THIS YEAR THIS FBRIOD TOTAL DEFF WOY 0000000005 000 HONDA 52000 01 05 1999 01707 1999 1 75 000 00 72 370 50 276 64 276 64 276 64 09 26 0000000005 000 HONDA g2000 OF 52000 ID SALES 01 05 1999 01707 1999 I 1 STEZA 7 679 10 Total c orparv 75 000 00 TO UD rrr 1 05 74 2 905 74 72 074 26 Lxduct dept af disposals Err Add balancing Dx eT 23 Lxduct a disposed transfers afrevialadd assets Total ad ustetdents 75 000 00 73 047 17 COO OG 1 905 74 S T 2 705 74 Cd 26 Once the End of Year is run the inactive fully Transferred asset will be deleted The total depreciation for the Transferred asset 2629
79. se note that before proceeding with this routine we recommend you to take a backup beforehand so that if you perform the procedure incorrectly you may still revert to your old data What are the recommended system requirements to operate the software Listed below are the basic requirements to operate Catsoft Assets Intel Pentium based PC 166MHz and above 32MB RAM minimum 64MB RAM Recommended 500MB MB Hard Disk space and above recommended 5 Window operating system MS Windows 95 98 ME 2000 XP If you are planning to network the program you are recommended to install it on the workstation on the server The workstations should be looking at the server s data folder ie X ASSET40 DATA This will enable the workstations to share access to the data Does Catsoft Assets have a Simplified Tax System STS function Catsoft Assets does provide this function In the Asset Type section categorize the assets you want to add STS calculation and set the depreciation rate to them To depreciate the asset for tax purposes enter the Update Assets screen select the asset for the STS calculations then enter the original purchase date and deemed date for that asset Then enter the date 6 months later in the Date Tax to Begin section to calculate How long has Catsoft Assets been in the market Since 1984 76
80. ss any report How to forecast depreciation for all the assets for the next 5 years An error message Invalid Depreciation Value or Invalid Tax Value appeared The assets of company A appear as assets of company B Assets with overstated This Year depreciation An Error message Assetlite Line 559 Error appears An Error message Date Book to being is later than the period start date appeared If depreciation for a particular period is already processed can it be unprocessed Can the system forward process depreciation Please provide the list of main asset fields in the Catsoft Assets program Please provide the list of main additions or disposals reports for a given period in the Catsoft Assets program What are the additional software capabilities of the Catsoft Assets software Can all reports generated be exported to spreadsheets with titles and format in order Can and how do we run multi companies In Catsoft Assets when setting up an asset what fields are mandatory Can you transfer assets between companies and if so what profile stays in the old company and what moves to the new company What happens if there is an error in the to an asset in Catsoft when the residual is paid out Is there any liability to transfer a leased asset to an asset in Catsoft Assets Can you give me a rundown on the security profiles in Catsoft Assets Can construction in process items be handled If so how need more details
81. sswords by means of the user security entry screen see below 53 User User 955 Password Fem Security First Prior Next Last_ Whenever the user logs onto the Catsoft Assets database they must type in a user name and password before they have any access to the database If there are multiple databases in different drives or directories the user must enter a user name and password each time they change the active data path Hence if there was an organisation with two companies and it was desirable to allow some users full access to one company database but view only access to the other this could be accommodated 54 Appendix B Frequently Asked Questions FAQs Default username and password 2 Depreciation charges not calculating T 8 J 2a Asset entered after period roll 2b Only reducing balance assets affected 2c New entry with accumulated depreciation included 2d Depreciation limit may have been reached 2e Method of depreciation specified without a rate How to perform a quick backup using Winzip How to install zipped data DATA zip into Catsoft Assets What are the effects of freezing an asset Some assets or companies are missing 6a Incorrect data path 6b Wrong company selected 6c Damaged index file s Edit the depreciation rates and methods Incorrect Disposal Transaction End of year routine cannot be done It takes a long to time proce
82. t Depreciation for minimum of 5 yrs There is a specific forecasting facility under reports in version 4 04 allowing the user to forecast depreciation for up to five years in a delimited file format compatible with spreadsheet applications such as MS Excel and Lotus 1 2 3 Enable DV calculations The user can select Reducing Balance as the method of depreciation to depreciate an asset by diminishing value The written down value of an asset at the beginning of each financial year is used as the basis for depreciation Enable pooling A user can pool assets together using the Asset Type category In this way assets associated with an Asset Type will utilize the method and rate of depreciation set against it Accommodate JV ownership arrangements he user will have to enter the asset in twice or more depending on the number of parties involved in the joint venture The cost of the asset must be pro rated against each party s respective interest in the asset The asset code can be the same for each asset to reflect that the asset is identical but with a different asset extension sub asset code to represent the different ownership arrangements Each asset entry is then recorded against different department or cost centre codes to achieve accurate cost allocations Enable assets to be classed Using the Asset Type category as described above Where expense allocation is the issue the user can associate assets against different department
83. t exist it will create a blank set of database files for you Another possibility is the user selecting the wrong company from the company list Check that the right company has been selected and not the Catsoft Demo Company 99A To select a company to work with click on FILE SELECT COMPANY The index file may be damaged An analogy would be the index section of a book If a page is added or removed from the book and the index section not updated referencing would be affected oimilarly in the Catsoft program if the index file is damaged reports could reflect incorrect information The database appears corrupted because some assets appear to be missing Examples a disposal entry could appear more than once in the disposals report an asset type with the description of UNKNOWN could appear in the book journal report PRECAUTION TAKE A BACKUP OF THE DATA FIRST BEFORE REBUILDING If the index file is damaged select UTILITIES REBUILD INDEX By rebuilding the index of the database the index files are reconstructed taking into account any new assets entered into the database or assets deleted or disposed of during the financial year 60 Q7 AT Q8 A8 Q9 A9 Q10 A10 Edit the depreciation rates and methods Depreciation rates and methods can be changed This can be done by specifying an overriding depreciation method and or rate for each asset individually or if all assets within an asset type are to be af
84. this screen is CAPEX Budget Code CAPEX Order Code Order Date Enter the date when the order for the budgeted asset is placed Order Amount Enter the dollar amount for which the ordered asset will be purchased Length 10 numeric characters Maximum amount 99 999 999 99 35 TRACKER REPORTS The Tracker Reports consist of an Assets Ageing Report and a Disposals Report The Ageing report gives a listing of assets within their respective age groups over 5 years while the Disposals tracking report supplements the existing standard Disposals Report by maintaining a record of assets disposed in over a year ago This gives the user an added advantage in enabling him or her to use the previous year s values as a reference point in deciding the current s year s optimum asset portfolio Ageing Report From the main menu bar select Reports Tracking Reports then Ageing Report Its filter screen is broken down into Range and Options aj Asset Ageing Report 2 E Range allows the user to limit the selection of assets to a specified range while Options Ss From allows the user to choose what they want displayed in this case the user can select Department the age groups they wish to view and an ost centre Location option to break the page at the end of each P Location category of assets Purchase Date Depar Cost This report displays the purchase date of each asset its purchase price plus its book writt
85. tion in the Asset screen is optional e Department Each company you create must have at least one department under it A department must be created before it can be referenced by any asset or by any report e Asset code The Asset Code you key in must not belong to an existing asset This field must have a unique number assigned to it e Any additional descriptions required for identification registration no serial no model no etc There is a section for Serial Number and any description of the asset in the Update screen These fields are optional e User We have a user routine in the Catsoft Asset package whereby users of the software can insert their own username and password to prevent any unauthorized used of the package 9 e Monthly update of the asset Users can update the assets each month by going into the Update screen and the depreciation calculation will take into account any changes made to the asset e f any major overhauls or extension are made to an asset on a subsequent date to identify these separately There are two requirements for approaching this requirement 1 They can re value their asset and change the description For example The BL is 1M and the upgrade is 100 000 They can then update this asset under the Revaluation Field as 1 100 000 Then go to Description field to include the additions 2 hey can use the Sub Asset Code which is the additional box to the right of the field box Asset C
86. tsoft Installation screen appears click on the Continue button to install the new software A Catsoft Product screen will appear after the installation screen has completed Then double click on the program icon Assets After the installation process when prompted for a licence number please enter your licence number labelled on Disk 1 When prompted for a username and password type in ASSET in both fields and click OK Running Catsoft Assets 4 04 To run Catsoft Assets version 4 04 please follow these instructions Windows 95 98 ME 2000 XP Click on Start Select Program Select the relevant folder e g Catsoft Products Select Catsoft Assets 4 04 You will then be greeted by a sentry window requesting for a User Name and Password Welcome to Catsoft Assets 404 Please type your user and password ta enter the program Be i prem a As i dy Default Password The Level of User Access To change the level of user access go to the Utilities menu and select Users To add a new user simply click on Add and enter the user name password and Security level of access The following lists the level of access which can be given to users Level 1 Lowest Level Level 1 access allows users to view Data Entry Screens Users on this level cannot access Routines and certain options under Utilities the mport Utility if applicable the Rebuild Index function or the Backup Resto
87. tuation increase the depreciation value or the tax value by 1 00 and freeze the asset Then edit the asset again this time decreasing the depreciation value or the tax value by 1 00 In addition adjust the Date book to begin or Date tax to begin to the correct date e g the start of the financial year Save the changes The assets of company A appear as assets of company B There are cases where the assets of company A appear in the assets list of company B In such cases the index file may be damaged corrupted To resolve the situation select Utilities Rebuild Index Take a back up of the data before proceeding with the rebuild function Assets with overstated This Year depreciation In this situation a user may have changed the book and tax depreciation rates for the assets during the financial year and have forgotten to freeze the assets thus causing the This Year depreciation figure to be overstated To resolve the situation Determine if there are any inactive assets in the database e g disposed assets transferred assets revalued assets If there are transfers of assets do not proceed with the following procedures Assuming these is no transferred assets go to Windows Explorer and select the path where the data is stored e g C catsoft assets40 data In the Data folder rename the DISPOS A DBF and REVAL AU DBF files into DISPOS A BAK and REVAL AU BAK respectively Next create a blank database in
88. ups made using the current version A Export Utility The Export Utility was created primarily for the purpose of copying data onto a spreadsheet A common ASCII text file is created this utility which can later be accessed via spreadsheet applications such as Microsoft Excel or Lotus1 2 3 Click here for a selection of the various types of data that can 2 be exported Export Type 5 5 12 E Company Code Range From W To With each data type teld Separator Character m you select you will be OPTIONS able to specify a range Include Field Names Include In Date of records you wish to Quote Character Field Suppress Null Numeric Field export with reference to the primary key e g Company Code The field separator character will separate the various fields within a record by appearing between each field You must select a field separator also known as a delimiter that is not used in any of the descriptive fields contained in the records you wish to export e g the may be a better choice 66 37 than more commonly used After specifying the path and the name of the output file click on OK The file you specified will then be created within the path specified You can then access that file via your spreadsheet application to obtain the exported data contained therein NB The way each spreadsheet application handles text files may differ Hence you m
89. y c database 8 W Vhat are the system requirements to operate Catsoft Assets Does Catsoft Assets a Simplified Tax System STS function low long has Catsoft Assets been in the market 56 Q1 A1 Q2 A2 A2a A2b A2C A2d A2e Username and password The default username and password is ASSET for both Depreciation charges is not calculating for certain assets Depreciation charges may not be calculating for one of the following reasons The asset was purchased during the period in question but was not entered until after the period was rolled Roll the period back then forward again Example currently financial year is 01 07 2001 to 30 06 2002 periods rolled monthly If the new asset is entered with Purchase Date and Date Book Tax To Begin of 15 12 2001 roll the period to 30 11 2001 and then repeat period end to 31 12 2001 again depreciation will recalculate for December Only assets using the reducing balance method of depreciation are affected To overcome this problem restore a backup of the data taken before the upgrade and freeze all assets be fore rolling the period forward The asset is a new entry with accumulated depreciation entered against it The entry may be an asset that has already been depreciating but does not currently exist in the database The asset is entered with its original purchase details while accumulated depreciation up to the end
90. y way That all depreciation be duds in the current p period ing TR and therefore throwing the accounts out 45 Once client has decided to g go wit n Catsoft is there a way in downlc information as opposed to maimai a T 46 dd sed ae d by Smp pany 4T Can C atsoft Assets p a tra Minis of Capital W orks in Progress transferring to asset register 48 Can Catsoft Assets enable Book and Tax Depreciation in compliance accounting standards Es assets 49 Can we export the G CSV format 50 ini aic Y Costs on ihe Asset i ie Book Tax ea rur hewn m expenditures and E d E 2 51 Why 2 are Tn no f dur and sal Depreciation or Book Depreciatio S 92 How does the program use the ife f for each asset 1 depreciation 03 How does the program retain historical data such as original cost and prior cumulated c price o calculate book i WD j i whe dr vius ue is nel d t ie V W IDV 55 How Hie ie program extract the data for deu 56 a does the program import initial data 57 Company A is using one database for the fixed assets This c NZ branches where the amounts entered are in i dollars How can we these two NZ branches from the existing database anc ni ient Ib a new NZ onl

TABLE OF CONTENTS

Contents

Download Pdf Manuals

Related Search

Related Contents