Open Forum

Expand all | Collapse all

Can I have Multiple AP Subledgers

  • 1.  Can I have Multiple AP Subledgers

    SILVER CONTRIBUTOR
    Posted 18 days ago
    Good morning,
    We are planning to move our broker pay out of payroll and into a separate department since they are not actually employees. We would like to keep this separate from the operational AP accounts and subledger - is this possible?

    Many thanks,

    ------------------------------
    Beth Cole
    Seaboard Transport
    Halifax
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Can I have Multiple AP Subledgers

    TOP CONTRIBUTOR
    Posted 18 days ago
    @Beth Cole,
    Do you have Vendor Classes set up? If not, this would be the best way to accomplish what you want. You need to ​create a Class for this group of Vendors and when you run the AP Trial Balance you can restrict it to this one group of vendors. I recommend putting a "Z" in front of the Vendor Class name so that when you run a TB for all vendors other than the Brokers you can select classes A-Y and exclude the Z.

    ------------------------------
    Barbara Gavron
    Atlantic Beach / Jacksonville FL
    904-536-0129
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Can I have Multiple AP Subledgers

    SILVER CONTRIBUTOR
    Posted 17 days ago
    I agree with @Barbara Gavron - we have 'intercompany' vendors and we do that exact thing.
    We have a vendor class named 'Z-INTERCO' and all intercompany vendors  - one vendor for each of our 15 operational entities​ - are in this vendor class.

    The other reason we separate our interco vendors from normal trade payables is that the AP control account for each interco vendor is the 'interco due to' GL account in the chart of accounts.

    You could do the same thing with Broker Pay - create a separate AP control GL account for Broker Pay, assign that control account to the Broker Pay vendor class as well as to each vendor in the class.

    Then when you run AP Trial Balances or run vendor payments, you can keep Broker Pay separate from trade payables.

    ------------------------------
    Jeff Pfershy
    Sr Business Analyst
    BluJay Solutions Inc
    Holland MI
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role