Accounting Project and Finance

Follow
When using Uniconta project, it is necessary to ensure the setup of the account assignment. The principles are as follows: There are two main types of invoicing On-account billing and invoicing. The idea in Uniconta is that a "End Invoice" / "Create Order" ends a period or a project. Invoices on account are invoices that provide capital, but no income in finance. This idea can be deviated from depending on whether work in progress integration to finance is used or not, so different scenarios must be considered. This can be illustrated in this way:
Your project To Finance
Text Amount of money Moms Account Account type Moms Debit Credit
Cash on delivery 10.000 2.500 Ongoing Status 10.000
Debtor omnibus account Debtor 12.500
Value added tax Outgoing VAT U25 2.500
Final invoice
Text Amount of money Moms Account Account type Moms Debit Credit
Sales value 25.000 6.250 Turnover Drift U25 25.000
Cash on delivery -10.000 -2.500 Ongoing Status 10.000
Total 15.000 3.750 Debtor omnibus account Debtor 18.750
Value added tax Outgoing VAT U25 3.750
If work in progress is used, the coding can be illustrated as follows:
Your project To Finance
Text Amount of money Moms Account Account type Moms Debit Credit
Cash on delivery 10.000 2.500 Ongoing Status 10.000
Debtor omnibus account Debtor 12.500
Value added tax Outgoing VAT U25 2.500
Registration
Number of a taken Total Account Account type Moms Debit Credit
25 1.000 25.000 Ongoing Drift 25.000
In progress Status 25.000 -
Final invoice
Text Amount of money Moms Account Account type Moms Debit Credit
Sales value 25.000 6.250 Turnover Drift U25 25.000
Cash on delivery -10.000 -2.500 Ongoing Drift 25.000
Total 15.000 3.750 Ongoing Status 10.000 25.000
Debtor omnibus account Debtor 18.750
Value added tax Outgoing VAT U25 3.750
In Uniconta, a project is complete when everything is invoiced and sales value = 0
  1. Ongoing work with integration to finance
  2. Invoicing on account
    1. There are two types of Aconto invoices (NOTE: The project type type in the order header Project type must be type "Aconto")
      1. As a Sales Order
        1. A service item number must be created that posts the Aconto amount in Status. Offsetting items come from the Debtor summary account.
      2. As Aconto invoice from project
        1. Same as above, but currently not available.
    2. The Aconto total is shown on the Project in the Aconto field and in the Aconto column on the Work in Progress report.
  3. Final invoicing
    1. Created from Project (Create order) or the Work in Progress report
      1. All registrations including Aconto are transferred to a sales order.
      2. The amount to be finally invoiced can optionally be entered manually.
      3. After invoicing, the Sales value for the project/period = 0 and everything is set to invoiced for the Period/Project.
  4. Zero invoice
    1. Created from Project (Create Zero Invoice) or the Work in Progress report
      1. All registrations including Aconto are transferred to a sales order.
      2. The order total is set to 0 and no invoice is sent.
      3. After invoicing, the Sales value for the project/period = 0 and everything is set to invoiced for the Period/Project.
  5. Sales order for Project
    1. On a Project sales order, you can select a "Project type" with the type "Revenue". This type does the following
      1. When invoicing is created
        1. A line with Project type type "Revenue" on the invoice totals the amount
        2. One line per invoice line with the Project type on the item.
      2. All invoice lines add up to 0 in sales value on Project items
      3. There is no work in progress
 
  1. None Ongoing work with integration to finance
  2. Invoicing on account
    1. On-account invoices that are recognized as revenue
      1. There are two types of Aconto invoices (NOTE: The project type type in the order header Project type must be type "Aconto").
        1. As a Sales Order
          1. No item number is entered. Account assignment is taken from the Debitor group
        2. As Aconto invoice from project
          1. Same as above, but currently not available.
      2. The Aconto total is shown on the Project in the Aconto field and in the Aconto column on the Work in Progress report.
    2. On-account invoices that are not recognized as revenue
      1. There are two types of Aconto invoices (Note: The project type type on the order header Project type must be type "Aconto")
        1. As a Sales Order
          1. A service item number must be created that posts the Aconto amount in Status. Offsetting entries come from the Debtor summary account.
        2. As Aconto invoice from project
          1. Same as above, but currently not available.
    3. The Aconto total is shown on the Project in the Aconto field and in the Aconto column on the Work in Progress report.
  3. Final invoicing
    1. Created from Project (Create order) or the Work in Progress report
      1. All registrations, including Aconto, are transferred to a sales order.
      2. Enter the amount to be finally invoiced.
      3. After invoicing, the Sales value for the project/period = 0 and everything is set to invoiced for the Period/Project.
  4. Zero invoice
    1. Created from Project (Create Zero Invoice) or the Work in Progress report
      1. All registrations including Aconto are transferred to a sales order.
      2. The order total is set to 0 and no invoice is sent.
      3. After invoicing, the Sales value for the project/period = 0 and everything is set to invoiced for the Period/Project.
  5. Sales order for Project
    1. On a Project sales order, you can select a "Project type" with the type "Revenue". This type does the following
      1. When invoicing is created
        1. A line with Project type type "Revenue" on the invoice total amount
        2. One line per invoice line with the Project type on the item.
      2. All lines of the invoice add up to 0 in sales value on the Project