Download
cnet erp accounting management n.
Skip this Video
Loading SlideShow in 5 Seconds..
CNET_ERP Accounting Management PowerPoint Presentation
Download Presentation
CNET_ERP Accounting Management

CNET_ERP Accounting Management

155 Views Download Presentation
Download Presentation

CNET_ERP Accounting Management

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. CNET_ERP Accounting Management Course # 2505

  2. Contents • Setting up CNET_ERP Accounting • CNET ERP Accounting Architecture • Source Documents • Journals Posting • Ledger • Reconciliation and auditing • Closing and Reporting

  3. Setting up CNET_ERP Accounting Part One

  4. Setting up CNET_ERP Accounting • Maintain Global System Library (GSL) • Maintain Chart of Account • Setup accounting Period • Default account setting • Account integration • Beginning balance • Proof reading and checking setting

  5. Maintain Global System Library (GSL) 1.1

  6. Company setup • Company Name • TIN No • VAT No • System Type • Address

  7. Global System Library (GSL) • Items - Non processed raw material • Products – Processed value added Product • Finished Product and None finished Product. • Customers – Buyers, Guests, Patients… • Suppliers – Seller, vendors, provider • Employees – Workers of the organization • Miscellaneous – Various

  8. Global system library illustration Global System Library (GSL) Sales Module Inventory Module Accounting Module FBM Module • Customer • Item • Product • Employee • Supplier • Item • Product • Employee • Customer • Supplier • Employee • Item • Product

  9. Item/Products • General • Price list • Supplier list (Only for item) • Balance list • Specification list • Catalogue list • Package • Advanced • Master record • Medicine, Book, Electronic, Garment,

  10. Customer/Supplier • General • Address • Local Address • International Address • Advanced • Picture • Translator

  11. Employee • General • Address • Local Address • International Address • Advanced • Picture • Translator

  12. Miscellaneous Department Cart Period Commission Font Fixed Asset Class Cost factor • Bank • Tax • Message • Lookup • Table • Item category • Store • Exchange rate

  13. Methods of Maintaining GSL • Automatic (Using data migrator) • From Excel (Standard formats) • From Pervious version of CNET_ERP V.4.0 • During Synchronization • Fast Registration • Manual maintenance • All GSL maintenance are found on maintain main menu. • Maintain history

  14. Methods of editing GSL • From maintain dialogue box • Must select the GSL to edit • Make changes and save • From editing list • Excel like sheet • Has searching criteria • Multiple editing at once • Takes effect after saved • Edit history

  15. Maintain Chart of Account 1.2

  16. Chart of account • CNET_ERP Accounting follows A tree structure / parent-child structure. • Account type • Control account • Subsidiary account • Standard account types are provided in the system dictionary. • All transaction are made at subsidiary level • Coding standard • Max 6 digit for Control • Max 6 digit for subsidiary • Select separator from special character • “-,_,*,+,.,/,\,|, space,<,>,^,@,!,#,$,%,&,{,[,],},:,;,”,’,. • Max total code length <= 13 “100010-300040”

  17. Maintain Chart of Account • Cash Account • On hand, at bank, pity cash, purchaser … • Revenue Account • Item categories, room, board, add. Charge… • Expense Account • General, utility, maintenance, departments… • Account payable (A/P account) • Suppliers, vendors… • Account receivable (A/R account) • Customers, Agents, Dealers… • Tax account • VAT, Withholding, Income tax ... • Default Accounts

  18. 1.3 Setup accounting Period • Ethiopian or European Period • Number of period • Can be 12, 24, 36, 48 • Set a Starting Date • Automatically generate accounting periods.

  19. Default account setting 1.4

  20. Default Account Setting

  21. Default Account Setting

  22. Account Integration 1.5

  23. Account integration chart Item/Product Cost of sales Inventory Customers Revenue Account Receivable Suppliers Account Payable Cash at bank Room/Board Cash on hand ... Bank/Credit card ... ... User/Cashier ...

  24. Account integration • Item/Product • Customer/Supplier • User (Cashier) Account setting • Credit card account setting • Room Revenue account setting • Board revenue account setting • Bank account setting

  25. Item/Product Account integration • By Item category • Parent account to child category • Child Category to items account inheritance • By individual item • Accounts • Revenue • Cost of sales • Inventory

  26. Customer/supplierAccount integration • By customer category • Maintaining account for customer category • Account inheritance • By individual customer

  27. Cashier Account Setting • All user that transact cash must have account • Cash on hand account • If no account assigned for a user system takes default cash on hand account

  28. Credit card account setting • Miscellaneous section • All credit card must have account • Cash at bank or account receivable • If no account assigned for a credit card system takes default cash at bank account

  29. Room Revenue account setting(Hotel) • Assuming different Room type revenue will be posted in different account • Room type based revenue account • If no account assigned for a room type, system takes default sales account

  30. Board revenue account setting(Hotel) • Assuming different board revenue will be posted in different account • Mostly board revenue is a food revenue • Room type based revenue account • If no account assigned for a room type, system takes default sales account

  31. Beginning balance 1.6

  32. Beginning balance • Account balance • Item/Product beginning balance • Customer/Supplier beginning balance • Employee beginning balance

  33. Account beginning balance • Periodical • Balance will be effective as of the selected Accounting period • Must balance • A trial balance • Natural balance is respected • Proof read conformation

  34. Item/Product beginning balance • Must have a store and one of the store must be main store • On item maintain form, balance list • Must select the store and type in the balance in the respective field • Beginning cost must be on the main store • Beginning balance can be on the respective store

  35. Customer/Supplier beginning balance • On maintain customer form general tab • Must have account

  36. Employee beginning balance • On maintain employee form general tab • Must have account • Other alternative is on accounting setting user account setting • Especially all cashiers must have account

  37. 1.7 Proof reading and checking setting • GSL Report • Chart of account • Period report • GSL check list for account integration • No account, No category, No supplier... • Beginning Balance Report • Default Account setting Report

  38. CNET_ERP Accounting Architecture Part II

  39. CNET_ERP Accounting Architecture • Layered detachable architecture • Source document layer • Voucher / Transaction • Journal layer • Five /5/ Journal • Leger layer • General lager (Group by account) • Trial balance (Summarized by account)

  40. Architectural illustration Leger Journal SourceDoc.

  41. All Business Follows the same pattern. 21st century Accounting GAAP

  42. 2.1 Vouchers (Transactions) Source Document layer

  43. Vouchers (Transactions) • Transactions are made out of one or many GSL • Transactions are curried via Vouchers • Vouchers are building blocks of subsystems • There are 39 Vouchers in 5 Subsystems in CNET_ERP V.5.0 • Vouchers are source documents • Will take effect after being issued • Voucher will be further processed to produce Journal

  44. Kinds of Vouchers • With respect to structure • Line Item Voucher (29 – 75%) • None line item Voucher (10 – 25%) • With respect to Stock movements • Stock Moving • None Stock moving • With respect to Accounts • Journal Voucher • None Journal Voucher

  45. Vouchers and Sub systems division • Core Sub system • Sales (7) • Inventory (15) • Accounts (7) • Extended Sub system • Front office management (3) • Productions management (7) • Human Resource management (-)

  46. Rules of Vouchers • Sequentially Numbered • Need time stamp • Need one or more owner • Should be contained in a single page • Can not be modified after being issued • Need a copy distribution management (CDM) • Can be void • Must support multiple print size and formats • Has execution procedure

  47. Line Item and None Line item Vouchers • All Sales, inventory and production Vouchers are line item vouchers • All Accounting Vouchers and FOMS vouchers are non line item vouchers • Dual Life vouchers • Credit sales (FOMS Room sales) • Refund (FOMS Room Refund)

  48. Parts of line item voucher Value section Cart Section Batch section Payment method Store Section Operation Section Reference section Purpose section • Address section • Item Information/ (Nested reference) • Command section • Item collector • Term Section • Summery Section • Voucher no Section

  49. Parts of non Line Item Voucher • Address Section • Reference section (Nested) • Tax Section • Account Section • Voucher No Section • Amount Section • Description Section • Cart Section • Payment method section • Operation Section

  50. Sales subsystem • Sales Order • Performa Invoice • Cash sales Invoice • Credit sales invoice • Sales return (Refund) • Consignment sales invoice • Consignment sales return