MKG logo
Login

Entry 22: Internal Invoicing (manual)

Example entry 'Internal Invoicing' in the journals 'Hours', 'Sales', and 'Purchase' following the action 'Internal Invoicing of hours in the source administration'. Transaction types 07 Hours, 03 Sales Cost Price, 14 Manual Sales Invoice, and 09 Purchase Invoice.

 

 

 

Manual: Internal Invoicing
   
 Transaction 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 G/L Account Amount Type DC Transaction subtype G/L Origin
1 Cost man-hours (002/4500) 7600 (Cost price man-hours) € 224,00 Debit 12 Hours Costs Hour Type/Operation
2 Cost machine hours (002/4500) 7601 (Cost price machine hours) € 80,00 Debit 12 Hours Costs 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
   
   
 Transaction type: 03 Sales Cost Price
 Action: Internal Invoicing of hours in the source administration
 Journal: Sales
 Note: Part 2: cost price entry of the invoice (from part 3). The entry is made based on the configuration of the cross table/sales group.
   
Seq.no. Description G/L Account Amount Type DC Transaction subtype G/L Origin
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/Inventory Group
4 Acc grd man 7601 (Cost price machine hours) € 80,00 Credit 27 Machine Cross Table/Inventory Group
   
   
 Transaction type: 14 Manual Sales Invoice
 Action: Internal Invoicing of hours in the source administration
 Journal: Sales
 Note: Part 3: revenue entry 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 G/L Account Amount Type DC Transaction subtype G/L Origin
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
   
   
 Transaction type: 09 Purchase Invoice
 Action: Internal Invoicing of hours in the source administration
 Journal: Purchase
 Note: Part 4: in the target administration, the purchase invoice is posted based on the settings in the cross table.
   
Seq.no. Description G/L Account Amount Type DC Transaction subtype G/L Origin
1 Internal outsourcing 60200010/1/0 7400 (IC outsourcing assembly (hours)) € 304,00 Debit 77 Material Cross Table/Suspense Account Outsourcing
2 De Koning Montage bv 1600 (Creditors) € 304,00 Credit 16 Invoice Cross table/Creditor/Creditor Group
   
   
 Transaction type: 09 Purchase Invoice
 Action: Internal Invoicing of hours in the source administration
 Journal: Purchase
 Note: Part 5: in the target administration, the WIP entry is done.
   
Seq.no. Description G/L Account Amount Type DC Transaction subtype G/L Origin
1 WIP outsourcing 60200010/1 3503 (WIP outsourcing) € 304,00 Debit 15 WIP Outsourcing Production Group
2 Suspense account outsourcing 60200010/1 7400 (IC outsourcing assembly (hours)) € 304,00 Credit 80 Outsourcing Cross Table/Suspense Account Outsourcing

 

 

Explanation

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

 

Knowledge center
Financial Entries Overview
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 Entries
How to Set Up Journals
How to Use the Administration Cross Table

 

 

operationgeneral ledger accountoutsourcingdebtorjournalfinancial transactioncreditorcost pricedebit/creditrevenueinternal invoicingdebtor groupsales grouphour typecreditor groupproduction groupsourcetargetcross tabletransaction typejournal entrytransaction subtypetransaction type 03 sales cost pricetransaction type 14 manual sales invoicetransaction subtype 02 revenuetransaction subtype 01 invoicetransaction type 09 purchase invoicetransaction type 07 hourstransaction subtype 48 cost price mantransaction subtype 49 cost price machinetransaction subtype 26 mantransaction subtype 27 machinetransaction subtype 16 invoicetransaction subtype 80 outsourcingtransaction subtype 15 wip outsourcingtransaction subtype 13 hours accountedtransaction subtype 77 materialtransaction subtype 12 hours costs