Hi friends! We are so close on implementing a push...
# general
m
Hi friends! We are so close on implementing a push through for Company Credit Card Expense reports from Expensify in real time (vs. end of month upload). One issue we ran into is that the category drop down is a required field to fill in. Does anyone know how to change this so that it is not mandatory and an account can be selected? I've tried going to transaction forms under customization and was only able to figure out how to add the account with a drop down. I wasn't able to figure out how to remove the mandatory part of the category field
j
@MaryH to my knowledge this is not possible. I'd be curious if you find out different though. The workaround is to create an expense category for each account and just give it the same naming/numbering. A little tedious, but isn't too hard with CSV import.
k
Can't CSV import expense categories to my knowledge? Is there something I missed?
m
that's not the issue...I don't mind adding those in, but our CEO wants to keep categories to a minimal for our employees who have to fill out expense reports. So I guess the only other work around for us would be to reclass the expense from an other category account 😞
j
this?
k
OMG
I looked for hours...
m
or we just stick to the end of month upload, but it is delaying our month end process
k
How would they fill out expenses without a category?
m
we have a generic category other that goes to an account that we change at upload time, but since we are exporting directly from Expensify to Netsuite we would have to do a manual reclass
k
You could have a generic category - and then push from your category to the account with a journal entry
but then I still don't know how you would know which account it belonged in.
m
yes, JE seems like the only way around it
j
Yeah that sounds a bit like allocation schedules (i.e. based on % or headcount or whatever)
m
the reviewer of the reports updates the memo and includes it in the details
k
Why cant' they have categories that fit the type of expenses?
m
yeah...we do allocations too 🙂
k
In expensify I think you can turn off categories
👍 1
so they only have their 1 category that's available to pick
and then you do a CSV upload to update them and recategorize to the right category
j
Or if the "reviewer" is the one who actually knows where the expenses go, could they just enter the expense reports. Just a thought.
k
That said - that still feels like putting an undue burden on accounting that belongs on the person putting in expenses to categorize according to rules.
Unless they just don't trust people to categorize correctly...
m
no, our team is incredible and do an amazing job entering in their expenses into expensify. Accounting just reviews it in case something needs to be reclassed
the challenge is not categorizing it...it's making the category mandatory at export time....if it could go to an account instead (which I as able to insert into a field on the expense report in NetSuite) ....even if you enter in an account with the wrong category and save the default goes to the category not the account
k
I wish I had more ideas for you Mary - I'm not following your use case at all.
Might not be a bad idea for you to contact expensify directly and ask them.
what their suggestions would be
that said - I've had mixed results there
j
So your question is on the Expensify side? Each of your categories should be associated with one expense account when you set them up. Then your accounts and categories should line up 100%.
If it's an expensify question, you probably will have to contact them directly.
m
I have no issues on the Expensify side...categories are driven by Netsuite, but I will reach out to them to see if others were able to work around the category being mandatory
Thanks to you both. I appreciate your feedback!
I thought more about this yesterday and I think you guys are right about focusing on the categories. Yes, we should probably load our entire chart of accounts into categories and in Expensify since our CEO doesn't want all the categories showing I can actually deselect the ones that we do not want to show. I'll work on this after our month end close and let you guys know how it went. Thanks again! The synergy and collaboration here really helped me think through that!
I think I missed KevinJ's comment...that's exactly what he said above. Sorry Kevin!
k
No worries. I would suggest using a smaller batch of accounts that they could feasibly have expenses to, instead of your entire chart of accounts
👍 1
j
Yeah, that's typically what is done, but @MaryH your initial question made it sound like people needed to be able to choose from every possible expense account. Apologies if I misunderstood.
m
You guys are right...maybe I just add each account and deselect them in Expensify as needed vs adding the whole chart of accounts. If that's the case...I might be able to do that this month! 🙂
@James Morris I probably did not communicate that clearly 🙂. Thanks again!