controller’s office –general accounting physical inventory ... · pdf filephysical...

22
Controller’s Office – General Accounting Physical Inventory Report February 2017

Upload: nguyentruc

Post on 06-Mar-2018

216 views

Category:

Documents


3 download

TRANSCRIPT

Page 1: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

Controller’sOffice– GeneralAccountingPhysicalInventoryReport

February 2017

Page 2: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

DiscussionTopics

• CriteriaforanAsset

• WhyaNewPhysicalInventoryProcess

• UsingthePhysicalInventoryReport

• AdditionalInformation

• ImportantDates

Page 3: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

CriteriaforanAsset

• Anassetisdefinedasfurniture,fixturesandequipmentthathasavalueof$5,000orgreaterandhavingausefullifeofover2years.

Page 4: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

WhyaNewPhysicalInventoryProcess

• AssetsconvertedtonewPeopleSoftsystemwithconversion.

• ResponsibilityforthePhysicalInventorycounthasbeentransferredtotheController’sOfficefromConsolidatedServiceswiththeconversiontoPeopleSoft.

• AutomatethepastpaperinventoryreportsprocessandwilluseExcelspreadsheetsdistributedviaemail.

• ThisisPhaseIoftheautomationofthephysicalinventoryinPeopleSoft.

Page 5: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReport

PhysicalInventoryReport- Thisreportwillbeusedtoidentifyassetswithineachdepartment.

InventoryAction- Usethisareatoselecttheactiontakenforeachitem.

InventoryDetails- Allofthedetailscurrentlyidentifiedforeachitem.

Page 6: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReportInventoryAction:Found

Whenyouselectthisoptionitwillturnblue,indicatingthatyouneedtocompletecolumnsinthebluehighlightedareaofthereport.

Requiredfields:• Datelocated• SelectUnitize,Consolidate,orNA.Besureto

indicatetheitemsthatneedtounitizedorconsolidatedinthecomments.

Otherfieldsifapplicable:• Iftheinformationontheinventoryreportneedsto

beupdatedcompletecolumnsVthroughAC.

Page 7: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReportInventoryAction:Found

InventoryAction- Usethisareatoselecttheactiontakenforeachitem.

DateLocated- Thedatetheitemwasfound.

UnitizeorConsolidate-SelectUnitize iftheitemislistedontheinventoryreportasoneassetandinrealityitismorethanone.SelectConsolidate iflistedasseparateassetsandshouldbeone.

AdditionalInformation- Iftheinformationneedstobeupdatedusethesecolumns.

Page 8: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReportInventoryAction:NotFound

Whenyouselectthisoptionitturnsorange,indicatingthatyouneedtocompletecolumnsintheorangehighlightedareaofthereport.

DisposalCode:Lost/Missing/Stolen• Provideadisposaldate• Provideadocumentreferencenumber,orpolice

reportnumber.• UniversityPoliceReport• InventoryForm8(DeletionRequest)

DisposalCode:Casualty• Provideadisposaldateforwhenanitemwaslost

inaflood,fire,etc.

Page 9: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReportInventoryAction:NotFound

DisposalCode:Surplused• ProvideaDisposalDateforwhenanitemwas

takenoutserviceandtransferredtoConsolidatedServices.

DisposalCode:Transferred• Provideadateofdisposalforwhenaitemwas

movedtoanotherdepartmentorcampus.• ProvidetransferredOper Unit,FundCode,Class

Field,DeptID,andacontactname.• ProvideacompletedTransferForm7forall

transferreditems,ifnotdonesoalready.Foranyfuturetransferyoushouldalsousethisform.

Page 10: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReportInventoryAction:NotFound

InventoryAction- Usethisareatoselecttheactiontakenforeachitem.

DisposalCode- Iftheitemcannotbefoundusethisfieldtoidentifywhy.

DisposalDate- ProvideforitemswithDisposalCodesCasualty,Surplused,andTransferred.

DocumentRef- ProvidethePoliceReportnumberforitemsLost/Missing/Stolen. TransferredTo- ForTransferreditemsprovidetransferredOper

Unit,FundCode,ClassField,DeptID,andacontactname.

Page 11: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReportInventoryAction:Add

Whenyouselectthisoptionitturnsgreen,indicatingthatyouneedtocompletecolumnsinthegreenhighlightedareaofthereport.

Additionalfields:• AddinformationintheColumnsDthruR.

Note:Completeasmanyfieldsaspossiblesothatwecanidentifytheasset.

Page 12: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReportInventoryAction:Add

InventoryAction- Usethisareatoselecttheactiontakenforeachitem.

NewItemColumns- Foranynewlyaddeditems,completecolumnsDthruR.

Page 13: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReportInventoryAction:Special

Whenyouselectthisoptionitturnsyellow,indicatingthatyouneedtocompletethecommentcolumnhighlightedyellow.

Requiredfields:• Addacommentrelatedtotheitemthatdoesnot

matchanyoftheotherInventoryCodes.

RequiredAction:• SendanemailtoKevinO’Brientodiscusstheitem

inquestionanddecideanappropriateaction([email protected]).

Page 14: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

PhysicalInventoryReportInventoryAction:Special

InventoryAction- Usethisareatoselecttheactiontakenforeachitem.

Comments- AddacommentrelatedtotheitemthatdoesnotmatchanyoftheotherInventoryCodes.

Page 15: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

AdditionalInformation

• YourpointofcontactthroughoutthisprocesswillbeKevinO’[email protected]

• ThePropertyAccountabilityPolicywillnotbesentoutthisfiscalyearasitisintheprocessofbeingupdated.

Page 16: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

ImportantDates

• FormswillbeemailedFebruary27thruMarch3.

• FormsneedtobereturnedtoKevinO’BrienbyApril28th.

Page 17: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

WheretoFindtheResourcesReferencedinthisPresentation

Controller’sWebsite– GeneralAccounting:http://web.admin.sc.edu/ap

• ProceduresandFormsformanyprocesses- morebeingadded

Page 18: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

WheretoFindtheResourcesReferencedinthisPresentation

Page 19: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

GeneralAccountingResourcesContactUs:

GeneralAccountingContactGeneralAccountingforquestionsregarding:*JournalEntries *RQs*BankingTransfers *Assets*CapitalProjects *Tax*JournalVouchers*Endowments*TeamTravel*InternationalSuppliersandSalesUseTaxReturns.

EmailAddress:[email protected]

AccountsPayableandTravelContactAccountsPayableforquestionsregarding:*VendorPayments *Paymentrequest*APUploads *Refunds*Travel

EmailAddress:[email protected]

SupplierMaintenanceContactSupplierMaintenanceforquestionsregarding:*W-9 *NewSuppliers*W-8 *ChangestoSupplier

EmailAddress:[email protected]

[email protected]

Page 20: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

WheretoFindthisRecordedWebinarandPPT

Page 21: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments

QUESTIONS

Page 22: Controller’s Office –General Accounting Physical Inventory ... · PDF filePhysical Inventory Report Inventory Action: ... * Journal Entries * RQs ... * Journal Vouchers * Endowments