Transfer inventory products between subsidiary companies

SUGGESTED

Is there a better or easier way to transfer given inventory products between subsidiary companies verse having to enter an inventory adjustment for each and every item in both companies?

We are trying to implement a process that each company is receiving the required documents in order to process the move of products from one company and into the other, which inventory adjustments do not provided picking lists or purchase orders.

  • 0
    SUGGESTED

    Can you simply send them an invoice for what you are transferring?

  • 0 in reply to Best Business Strategies

    If we send an invoice, it hits sales/cost of goods leaving a balance to be paid.

    I'm assuming you are indicating we would set up an internal transfer customer account, which would be tax exempt as the transaction is not an actual sale of material but is there a way to set this account up so it does not show as an actual sale?

    Or would we have follow up and enter a Credit Memo for the amount of the invoice, hitting a specific GL account designated to track intercompany sales, and then apply this Credit Memo to the given invoice?

  • 0 in reply to DeniseGr
    SUGGESTED

    Send it to an asset or liability account.  Due to  XYZ company   and Due From ABC company

  • 0 in reply to Best Business Strategies

    Is there a recommended way in doing so?  Only asking as many things that should be straight forward unfortunately have not always been so within Sage 50 . . 

    Below are steps we have used to address various issues over time, which the third bullet point I am sure would not be used as it will result in the transfer transaction reporting as sales.

    • Add a line item to the invoice sending the total to the appropriate account, resulting in a zero balance invoice?
    • Enter a Credit Memo for the invoice total, applying amount to the appropriate account,, followed by connecting the invoice to the credit memo via Cash Receipts and/or Payments?
    • Enter a Cash Receipts and/or Payment applying the payment amount to the appropriate account
  • 0 in reply to DeniseGr
    SUGGESTED

    If you are transferring the inventory to another company, the other company still owes you for it.   If you are transferring back and forth between the two, send the invoices to an asset or liability account and balance out at the end of each month or quarter. 

  • 0 in reply to Best Business Strategies

    I agree.  Unless you are actually transferring money back and forth, you should keep the invoice open since the other company actually does owe the money to the company.  Set a long due date so that it doesn't show up as a late receivable.

    If you ever settle these balances, by actually transferring money between the entities then you apply that payment against these invoices.

    Thanks,
    Ron

  • 0 in reply to Best Business Strategies

    The statement to send the invoice to an asset or liability account is probably where I am getting confused. 

    Products are paid for by the parent company and the product needs to move to the appropriate billing warehouse, if you will.  So, yes this is an inventory transfer and not an actual sale of product and there is no actual money moving.  

    What I need to make sure is that the transfer of products does not end up reporting as a sale of goods until the actual sale occurs.

  • 0 in reply to DeniseGr

    Sales are INCOME accounts and they show up on the Income Statement.   These would show up on a Balance Sheet.

  • 0 in reply to Best Business Strategies

    Yes, I know Sales are INCOME and they show on the Income Statement as well as the Balance Sheet.

    Sage Support directed us to enter Inventory Adjustments to pull the material out from Company 1 and back into Company 2, but this completely messed with the books as well as does not provide the ability to submit a picking ticket to the warehouse.

    When you say, "send the invoice to an asset or liability account", is where I am trying to obtain clarification. Are you stating to physically change the A/R account # listed on the invoice, which leave's the invoice open, or to apply a credit or payment against the invoice hitting the asset or liabilities account, which closes the invoice out.

    I have been creating test entries and believe you are directing us to change the A/R account # on the invoice and then balance out monthly or quarterly by entering Receipt against the appropriate accounts as it is the only way to close out an invoice.

    I truly am sorry for all of this back and forth, but Sage Support has not been able to answer any of these questions and our accountant does not understand why we can not just create a GL. 

  • 0 in reply to DeniseGr

    Normally you create an invoice and the sale goes to the income account.  (DO NOT Change AR)  Change the number in the body of the invoice from an income Account to an Asset account ( Due From your company name.)

    I can remote in and set this up for you, but I do charge for my services.