Linking expenses to vendors, customers and employees in NetSuite

kglancy
kglancy Expensify Customer Posts: 2 Expensify Newcomer

We've recently been testing Expensify as an alternative solution to managing our company expense cards. We're really happy with the results so far except that the resulting journal entry connects the expense to the employee only. We need to be able to also connect this expense to the vendor and sometimes a customer. I presume this is a pretty common need and hope someone out there has found a solution for this problem. Help!

Answers

  • tylerzoll
    tylerzoll Approved! Accountant Posts: 430 Expensify Champion

    @kglancy there have been a few posts on this topic. You can create a custom script to do this that works most of the time. I would be happy to share what I have and you can customize to meet your needs if you are a suitescript pro. The script that I used is more for converting expenses to items, but it can be used for the same thing.

    I’ve never seen a good answer as to why folks need to do this though. I realize that QuickBooks does it, but what information does this reporting really provide?

  • iaingoldmann
    iaingoldmann Expensify Customer Posts: 3 Expensify Newcomer

    This is something we've done before. It is fairly straightforward, because the Netsuite 'Name' field on the journal line includes both Customers and Vendors.

    Challenge, as always, is the matching. The vendor on the card payment may not match exactly with the vendor name in NS. Also, potentially small payments don't need separate vendors. In theory, can get around this by autocreating vendors, this is a two edge sword, particularly if you have process to control who can be authorised as a vendor.

    I've seen various finance systems create vendors 'on the fly' and provide 'easy' reconciliation. But what they are really doing is simply taking and accepting cash outflows and creating whatever is needed in the finance system to let them through.

    Where we've bought in from Expensify before, we've bought in under a default, other than where the vendor matches.

    hope above helps

  • Darya
    Darya Expensify Customer Posts: 4 Expensify Newcomer

    Hi, @tylerzoll!

    I'd really appreciate it if you could share how the vendors can be mapped. We are moving from QuickBooks to Netsuite, and it startled me that QuickBooks offers more functionality in this case.

    As to why this is necessary: for example, we have a lot of recurring software and advertising charged to our company credit cards every month. Without vendor mapping, we would have no easy visibility into spend and reporting capability by vendor.

    Thanks!

  • Darya
    Darya Expensify Customer Posts: 4 Expensify Newcomer

    Hi, @iaingoldmann!

    Could you share the steps you took to have Expensify map the vendor from the credit card payment to the 'Name' field on the journal line?

    Thanks!

  • bhens
    bhens Expensify Customer Posts: 1 Expensify Newcomer

    Hi @Darya and @iaingoldmann - could you please also share with me the steps taken to get Expensify to map the vendor to the "Name" field on the journal line? Would be super grateful. Thank you!