We are new to Netsuite and trying to determine best practise for company credit cards.
Historically, how we have performed card transaction is that they are each entered under a CC vendor bill, using the reference number to identify specific employee cards. The main vendor is the card company, there for each card is entered for each employee, but under the same CC vendor. Each line item is matched to the aggregate expenses for that statement (example, auto fuel line item = all fuel costs from that card statement).
This system has two flaws: (1) lacking employee tracking/timeliness/responsibility for their own expense entries; (2) stuck creating backend journal entries when purchasing inventory using the cards and having to attempt to maintain a "Credit Card Inventory Clearing Account" to register and track incoming items, but badly.
In learning about Netsuite, it had appeared to be making some efficient connections in managing company credit cards, but now I am not so sure.
- I am confused by the lack of interaction/linkage between my newly created individual credit card accounts in the chart of accounts, and my main CC vendor / payee - these appear to miss each other or I do not know how to create that linkage for payments and looping in "use credit card" transactions, simple expenses (w/O req vendor), and paying vendors w/ CC.
- I was mostly concerned about inventory tracking and was happy to have a method of managing this in Netsuite, but now this is no longer clear to me if it will work.
- From what I have read in this forum, we also aren't interested in making a long list of new vendors to allocate simple expenses to (office supplies, fuel, one-offs, etc..) when I have accounts for that.
- I essentially need a hybrid where I can allocate payments to vendors via credit cards while continuing a basic expensing model (I don't have an issue reverting to the old way, if I can find a better way to manage the vendor payments required for CC-bought inventory (needs to go through standard PO/GRPO/Bill/Payment process)
I might just be dumb to the capabilities of the new Match Bank Data process, and would appreciate if anyone knows how to make something like this work. The SuiteAnswers doesn't appear to have much help either.
Or should we just go with old school and forget we saw this?!
Let me know if I need to clarify anything mentioned here. Thanks for any help you can provide