4.0 How To Set-up Analytic Accounting

  1. 1. Click on Accounting

    Click on Accounting
  2. 2. Click on Configuration

    Click on Configuration
  3. 3. Click on Settings

    Click on Settings
  4. 4. Search Analytics

    Search Analytics
  5. 5. Click on Save

    Click on Save
  6. 6. Click on Configuration

    Click on Configuration
  7. 7. Click on Analytic Accounts

    Click on Analytic Accounts
  8. 8. List of Analytic accounts

    List of Analytic accounts
  9. 9. Click on Configuration

    Click on Configuration
  10. 10. Click on Analytic Plans

    Click on Analytic Plans
  11. 11. Click on New

    Click on New
  12. 12. Type "Utilities"

    Type "Utilities"
  13. 13. Select Optional from Default Applicability

    Select Optional from Default Applicability
  14. 14. Click on Color

    Click on Color
  15. 15. Click on Add a line

    Click on Add a line
  16. 16. Select the relevant domains

    Select the relevant domains
  17. 17. Filling in restricts the accounts able to be added

    Financial Accounts prefix is based on Account Codes

    Filling in restricts the accounts able to be added
  18. 18. Filling in restricts the Products able to be added

    Filling in restricts the Products able to be added
  19. 19. Same as above. Select Optional makes the analytics optional

    Same as above. Select Optional makes the analytics optional
  20. 20. Click on Blue

    Click on Blue
  21. 21. Click on Analytic Accounts

    Click on Analytic Accounts
  22. 22. Click on New

    Click on New
  23. 23. Fill in relevant Analytic accounts

    For Example, Electricity & rent will be created

    Fill in relevant Analytic accounts
  24. 24. Creating the analytic account from within the plan automatically selects the plan. Amendable

    Creating the analytic account from within the plan automatically selects the plan. Amendable
  25. 25. Select a relevant customer if they are specific

    Select a relevant customer if they are specific
  26. 26. Repeat of step 22-24

    Repeat of step 22-24

Creating a bill with analytics

  1. 27. Click on Bills

    Click on Bills
  2. 28. Click on New

    Click on New
  3. 29. Select relevant product

    Select relevant product
  4. 30. Select Analytic distribution

    Select Analytic distribution
  5. 31. Multiple can be selected

    Multiple can be selected
  6. 32. percentage assigned to distribute the cost across bill account

    percentage assigned to distribute the cost across bill account
  7. 33. Click on Confirm

    Click on Confirm
  8. 34. Details of the product with the analytic Items

    Details of the product with the analytic Items

Applying Analytic accounts to already posted invoices

  1. 35. Click on Accounting

    Click on Accounting
  2. 36. Click on Journal Items

    Click on Journal Items
  3. 37. Search the relevant details of the entries

    For example, Vendor & Account code

    Search the relevant details of the entries
  4. 38. Uncheck on

    Uncheck on
  5. 39. Click on Analytic Column

    Click on Analytic Column
  6. 40. Select the relevant analytic account

    Select the relevant analytic account
  7. 41. Click on Close

    Click on Close
  8. 42. Click on Confirm

    Click on Confirm

Reviewing all the analytic items

  1. 43. Click on Accounting

    Click on Accounting
  2. 44. Click on Analytic Items

    Click on Analytic Items
  3. 45. Search relevant properties

    For example, analytic plan "Utilities"

    Search relevant properties
  4. 46. Switch the pivot mode for easier viewing

    Switch the pivot mode for easier viewing
  5. 47. Pivot Table of analytic accounts in Utility plans

    Pivot Table of analytic accounts in Utility plans