Intercompany integration solution for SAP Business One – Allocation of Income and Expenses across partner companies

[former_member186605]

Growing organizations that control more than one legal business entity are sometimes faced with the challenge of how to share data between partner companies.

The Intercompany integration solution for SAP Business One enables businesses running SAP Business One to manage Intercompany transactions for multiple companies by automatically replicating corresponding transactions across multiple company databases. Automating the replication of such transactions significantly reduces the amount of end-user effort needed to maintain Intercompany financial statements.

Intercompany Solutions allows user to allocate income and expenses such as travel, payroll, and audit fees across branch companies.

In this blog, we are covering following broad sections  on allocations:

1. G/L Branch Allocation


2. G/L Allocation Posting Templates


3. Recurring GL Allocation Postings


4. A/P Service Invoice Allocations

G/L Branch Allocation

User can use the G/L Branch Allocation feature to allocate income and expenses to other branch companies. For example, you can allocate income and expenses from the head office company to sales or distribution subsidiaries, or vice versa. The G/L branch allocation allows interbranch transactions to be posted automatically.

At the end of the month, an accountant can allocate a portion of any centrally incurred expenses across all organization units that contribute to, or benefit from, that expenditure/income, based upon a calculation that represents a reasonable allocation of how that expense/income should be split.

For example, marketing expense incurred in head office (ACME NY) company ledger is allocated to subsidiary 1 (ACME CA) and subsidiary 2(ACME TX).



 

Steps to create the G/L Allocation Transactions:

1. To create a G/L allocation transaction,Choose Financials-> G/L Branch Allocation to display the G/L Allocation window.


2. Specify header information i.e Due Date, Posting Date and Document Date etc.


3. In the top matrix,specify an amount in either the Debit (Income Allocation) or Credit (Expense Allocation) field depending on the nature of the allocation.


4. If required,you can add additional allocation lines in the top matrix.
   Please note Each row in the top matrix can correspond to multiple rows in the bottom matrix. Highlight the individual rows in the top matrix to populate corresponding allocation information in the bottom matrix.


5. In the bottom matrix,Specify the branch codes of the companies to which the allocation is to be made. You can use the Load All Branches button to automatically populate the branch codes of all branch companies.


6. If you specify the target company allocation account for a branch code in the Allocation Account Code field, then this allocation account will be used instead of the receiver company´s default expense account or default income account.


7. Choose add.


8. A journal voucher / journal entry is automatically created in the receiver systems – companies to which allocation is made.


9. In the journal voucher/journal entry, user can click the Intercompany detail button to see the sender company details and G/L allocation information.


10. Before posting the journal voucher, you can change the default expense account or the default income account to any other specific G/L account.


11. Change the Status field to Accept or Reject depending on your decision.


12. If you choose the status as Accept and update the journal voucher, the system sends an alert message to the Alert User of the sender system, indicating an update of the journal voucher.


13. Post the voucher.


14. The journal voucher is saved as a journal entry.


15. The status of the journal voucher is updated in the bottom matrix of the Allocation window in the sender system.

GL Allocation Posting Templates

Commercial organizations may have allocation transactions presented in a template format where only the recorded amounts vary from transaction to transaction. This feature enables the user to create pre-defined templates for expenses or profit allocation that can be used to record recurring transactions. For example, overall marketing expenditure to be allocated in a pre-defined percentage amongst the subsidiaries can be setup as a template.

Steps to create the G/L Allocation Posting Templates:

1. To create the G/L Allocation Posting Templates window, choose Financials->G/L Allocation Posting Templates.


2. Specify header information i.e Code and Description.


3. In the top matrix, Specify an amount in either the Debit (Income Allocation) or Credit (Expense Allocation) field depending on the nature of the allocation.


4. In the bottom matrix, Specify the branch codes of the companies to which the allocation is to be made. You can use the Load All Branches button to automatically populate the branch codes of all branch companies.


5. If you specify the target company allocation account for a branch code in the Allocation Account Code field, then this allocation account will be used instead of the receiver company´s default expense account or default income account.


6. Choose add.

 

Recurring GL Allocation Postings

Every business may have recurring transactions, say on daily, weekly, monthly or annual basis. This feature enables to create templates for recurring allocation postings, which can be executed based on the recurring frequency. Such recurring transactions can be configured in the Recurring G/L Allocation Postings screen. If the recurring transactions have been configured, the application prompts the user at application startup to post the scheduled recurring transactions.

Steps to create and execute the Recurring G/L Allocation Postings:

1. To create the Recurring G/L Allocation Postings, choose Financials->Recurring G/L Allocation Postings.


2. Specify header information i.e Code and Description and set the frequency according to which you want system to create instances for the transaction


3. In the top matrix, Specify an amount in either the Debit (Income Allocation) or Credit (Expense Allocation) field depending on the nature of the allocation.


4. In the bottom matrix, Specify the branch codes of the companies to which the allocation is to be made. You can use the Load All Branches button to automatically populate the branch codes of all branch companies.


5. If you specify the target company allocation account for a branch code in the Allocation Account Code field, then this allocation account will be used instead of the receiver company´s default expense account or default income account.


6. Choose add.


7. To execute the created instances,Go to Financials->Recurring G/L Allocation Postings->Confirmation List. The Confirmation of Recurring G/L Allocation Postings window appears, where each row represents one instance of a recurring G/L Allocation posting template.Please note to set the automatic display of this window, choose Administration->System Initialization -> General Settings -> Services. Select Display Recurring Postings on Execution checkbox.

 

A/P Service Invoice Allocations

Another way to allocate expense amounts to other branch companies is by using the allocation feature on the A/P Service Invoice document.
The application allows for allocation of expenses booked through AP service invoices across branch companies.

The Intercompany integration solution support following two methods of allocating expenses from an A/P service invoice.

• Allocation by Invoice – In this method of allocation, system creates draft A/R invoice as a result of allocation in the sender company. On adding these draft A/R service invoices, the system will automatically create draft A/P service invoices in the receiver companies.


• Allocation by G/L – This method of allocation is similar to G/L allocations. System creates the journal voucher in the receiving company as a result of allocation in the sender company.

Steps to create the Invoice Type Allocation:

1. Navigate to an open A/P Service Invoice and choose the Open Allocation button.


2. In the top matrix, select allocation type as Invoice. All other fields in the top matrix are drawn automatically from the A/P service invoice.


3. In the bottom matrix, specify the branch codes of the companies in bottom matrix to which the allocation is to be made. You can use the Load All Branches button to automatically populate the branch codes of all branch companies.


4. Choose Allocate button.


5. The system creates a separate interbranch draft A/R invoice for each branch company to which the allocation is to be made.


6. In the Documents Drafts Reports – Selection Criteria window,From the User dropdown list, choose the user and choose OK to display the interbranch draft A/R invoice


7. Open the draft and specify any additional information, if required, and choose Add.


8. The solution create the draft A/P invoice in the receiver system.


9. Open the draft A/P invoice document.


10. Before adding the document,you can change the default expense account to any other specific G/L account.


11. Choose the status as Accept and add the draft A/P invoice.


12. The system sends an Alert message to the Alert user of the sender system, indicating an update of the A/P invoice.


13. The A/P Invoice information is updated in the sender A/R invoice document on Intercompany Tab.


14. From the A/R Invoice ,user can open the allocated A/P Invoice by clicking the allocation Invoice reference number.


15. Also, the receiver companies A/P Invoice information is updated in the bottom matrix of the Allocation window in the sender system.

Steps to create the G/L Type Allocation:

1. Navigate to an open A/P Service Invoice and choose the Open Allocation button.


2. In the Top matrix, select allocation type as G/L. All other fields in the top matrix are drawn automatically from the A/P service invoice.


3. In the bottom matrix, specify the branch codes of the companies in bottom matrix to which the allocation is to be made. You can use the Load All Branches button to automatically populate the branch codes of all branch companies.


4. Choose Allocate button.


5. The system creates a separate journal entry corresponding to each row in the top matrix.


6. A journal voucher / journal entry is automatically created in the receiver systems – companies to which allocation is made.


7. Before posting the journal voucher, you can change the default expense account or the default income account to any other specific G/L account.


8. Change the Status field to Accept or Reject depending on your decision.


9. In the journal voucher/journal entry, user can click the Intercompany detail button to see the sender company details and allocation information


10. If you choose the status as Accept and update the journal voucher, the system sends an alert message to the Alert User of the sender system, indicating an update of the journal voucher.


11. Post the voucher.


12. The journal voucher is saved as a journal entry.


13. The status of the journal voucher is updated in the bottom matrix of the Allocation window in the sender system.

 

(This blog content was created by the development team of the intercompany integration solution for SAP Business One)

 

Find a list of all blogs on Intercompany integration solution for SAP Business One in this central blog.