Our home office likes to pay a bill to a vendor (many actually), and allocate it out to our 30+ branches (independently managed companies) and then collect reimbursements. What is the best way to do this with the Acumatica interbranch mapping where when I post the bill to mutliple line items (one for each branch) and then use the due to/from to create a corresponding AP invoice for the branch to pay us back and also create a corresponding open AR receivable in the home office to track all the reimbursements due?
Best answer by Laura03
Hello,
Each branch will need its own Bank Account. I suggest trying the steps in a test environment so you may study the resulting debits & credits & verify accuracy.
Enter & Pay Bills as described above. Acumatica records appropriate Due To/From entries on related branches.
Extend Branches as Customers & Vendors.
After the month is closed (or at Year-end), create an invoice in the Corporate branch for each not-corporate branch Customer having a non-$0 month end balance in the Due To Corporate Account as of the end of the prior month. The Invoice Debits Related AR account and Due To/Due From subsidiary account.
Subsidiary Branch enters the Corporate bill from step 3 and pays it, thus clearing the Due To Corporate balance from the prior month.
Subsidiary branches pay the Corporate invoices from their cash accounts.
Each branch will need its own Bank Account. I suggest trying the steps in a test environment so you may study the resulting debits & credits & verify accuracy.
Enter & Pay Bills as described above. Acumatica records appropriate Due To/From entries on related branches.
Extend Branches as Customers & Vendors.
After the month is closed (or at Year-end), create an invoice in the Corporate branch for each not-corporate branch Customer having a non-$0 month end balance in the Due To Corporate Account as of the end of the prior month. The Invoice Debits Related AR account and Due To/Due From subsidiary account.
Subsidiary Branch enters the Corporate bill from step 3 and pays it, thus clearing the Due To Corporate balance from the prior month.
Subsidiary branches pay the Corporate invoices from their cash accounts.
