Accounts Payable - can I set up multiple "vendors" (all from the same umbrella company) and record the payment (PAD) to them when the payment often includes multiple invoices from their various 'vendors'?

Setting up a new fiscal year for a franchise that deals with one very large umbrella company. The company has at least 10 different sub-companies that ships product, provides tech support, charges licensing fees, etc.

The umbrella company also takes payment via pre-authorized debit. Each PAD can include invoices from multiple sub-companies, there is absolutely no rhyme or reason to which invoices, and payment can be up to 2 months after the original invoice date.

For ease of entering individual invoices and tracking fees, tech, etc, I'd like to be able to set each one up as a vendor - and then match the PAD statement to one single vendor payment in Sage. Is there a way to connect multiple invoices from multiple vendors into one payment? Or what would be the best option?

The company previously just waited for the PAD to go through and then enter the lump sum as the invoice and note the sub-invoices (sub-companies). This made tracking very messy and time consuming, relying heavily on print-outs and notes.

Thanks for any help you can give!

Parents
  • 0

    I'm not sure I quite understand what you are trying to do but here's my interpretation of your situation.

    If you want to have - for example - 10 vendors set up such as ABC - 123 Tools, ABC - Joes Food, ABC - China Import, etc with ABC being the umbrella company, then you could pay each individual company from same PAD by showing the Chq nbr as - for example - PAD7423-1 for ABC - 123 Tools, then PAD7423-2 for ABC-Joes Food, PAD7423-3 for ABC China Import etc etc. The only issue is that each of the PAD7423 will show on bank ledger so you will need to total those to ensure it does add up to the original PAD7423.

    Is this what you were thinking of?

Reply
  • 0

    I'm not sure I quite understand what you are trying to do but here's my interpretation of your situation.

    If you want to have - for example - 10 vendors set up such as ABC - 123 Tools, ABC - Joes Food, ABC - China Import, etc with ABC being the umbrella company, then you could pay each individual company from same PAD by showing the Chq nbr as - for example - PAD7423-1 for ABC - 123 Tools, then PAD7423-2 for ABC-Joes Food, PAD7423-3 for ABC China Import etc etc. The only issue is that each of the PAD7423 will show on bank ledger so you will need to total those to ensure it does add up to the original PAD7423.

    Is this what you were thinking of?

Children
No Data