MKG logo
Login

Booking 22: Internal invoicing (manual)

Example booking 'Internal invoicing' in the journals 'Hours', 'Sales', and 'Purchases' following the action 'Internal invoicing of hours in the source administration'. Mutation types 07 Hours, 03 Sales cost price, 14 Manual sales invoice, and 09 Purchase invoice.

 

 

 

Manual: Internal invoicing
   
 Mutation type: 07 Hours
 Action: Internal invoicing of hours in the source administration
 Journal: Hours
 Note: Part 1: hours are processed according to the configuration of the hour type/operation
   
Seq no. Description General ledger account Amount Type DC Mutation subtype Source general ledger
1 Cost man-hours (002/4500) 7600 (Cost price man-hours) € 224,00 Debit 12 Hours cost Hour type/operation
2 Cost machine hours (002/4500) 7601 (Cost price machine hours) € 80,00 Debit 12 Hours cost Hour type/operation
3 Coverage man-hours (002/4500) 5000 (Coverage man-hours) € 224,00 Credit 13 Hours accounted Hour type/operation
4 Coverage machine hours (002/4500) 5001 (Coverage machine hours) € 80,00 Credit 13 Hours accounted Hour type/operation
   
   
 Mutation type: 03 Sales cost price
 Action: Internal invoicing of hours in the source administration
 Journal: Sales
 Note: Part 2: cost price booking of the invoice (from part 3). The booking is made based on the configuration of the cross table/sales group.
   
Seq no. Description General ledger account Amount Type DC Mutation subtype Source general ledger
1 CP man 7600 (Cost price man-hours) € 224,00 Debit 48 Cost price man Cross table/Sales group
2 CP mach 7601 (Cost price machine hours) € 80,00 Debit 49 Cost price machine Cross table/Sales group
3 Acc grd man 7600 (Cost price man-hours) € 224,00 Credit 26 man Cross table/Stock group
4 Acc grd man 7601 (Cost price machine hours) € 80,00 Credit 27 machine Cross table/Stock group
   
   
 Mutation type: 14 Manual sales invoice
 Action: Internal invoicing of hours in the source administration
 Journal: Sales
 Note: Part 3: revenue booking of the sales invoice. A manual sales invoice is automatically created, where the settings in the cross table determine which general ledger accounts are addressed.
   
Seq no. Description General ledger account Amount Type DC Mutation subtype Source general ledger
1 Machinefabriek De Koning bv 1300 (Debtors) € 304,00 Debit 01 Invoice Cross table/Debtor/Debtor group
2 Internal outsourcing 60200010/1/0 8000 (Revenue hours NL) € 304,00 Credit 02 Revenue Cross table/Sales group
   
   
 Mutation type: 09 Purchase invoice
 Action: Internal invoicing of hours in the source administration
 Journal: Purchases
 Note: Part 4: in the target administration, the purchase invoice is booked based on the settings in the cross table.
   
Seq no. Description General ledger account Amount Type DC Mutation subtype Source general ledger
1 Internal outsourcing 60200010/1/0 7400 (IC outsourcing assembly (hours)) € 304,00 Debit 77 Material Cross table/Intermediate account outsourcing
2 De Koning Montage bv 1600 (Creditors) € 304,00 Credit 16 Invoice Cross table/Creditor/Creditor group
   
   
 Mutation type: 09 Purchase invoice
 Action: Internal invoicing of hours in the source administration
 Journal: Purchases
 Note: Part 5: in the target administration, the WIP booking is done.
   
Seq no. Description General ledger account Amount Type DC Mutation subtype Source general ledger
1 WIP outsourcing 60200010/1 3503 (WIP outsourcing) € 304,00 Debit 15 WIP outsourcing Production group
2 Intermediate account outsourcing 60200010/1 7400 (IC outsourcing assembly (hours)) € 304,00 Credit 80 Outsourcing Cross table/Intermediate account outsourcing

 

 

Explanation

  • Mutation type = the journal entry resulting from the action has this mutation type.
  • Action = the action performed by the user.
  • Journal = the journal that is addressed.

 

Knowledge center
Overview financial bookings
How to set up sales groups?
How to set up production groups?
How to set up debtor groups?
How to set up creditor groups?
How to set up hour types?
How to set up VAT codes?
Administration settings for financial bookings
How to set up journals?
How to use the Administration cross table?

 

 

operationledger accountoutsourcingdebtorjournalfinancial transactioncreditorcost pricedebit/creditturnoverinternal invoicingdebtor groupsales grouphour typecreditor groupproduction groupsourcetargetcross tabletransaction typejournal entrytransaction type 03transaction type 14transaction type 09transaction type 07