Expensify.org is accepting proposals for new campaigns. Submit yours here by April 30th to receive up to $100,000 in funding for campaigns dismantling injustice related to: Climate, Homes, Hunger, Reentry, or Youth.
Exploring Accrual Accounting Workflows in Expensify

Every so often, Expensify needs input from our users when creating new features to help determine the best practices and most efficient workflows. Whenever we implement a new feature, our goal is to encourage adoption of these ideal practices by making them as easy as possible to adhere to. With this goal in mind, we're currently exploring what our users might want to see if we were to add an auto-accrual feature!
Here are some things we're wondering:
- Which accounting system are you using? Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)?
- What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient?
- Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging?
- Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting?
- How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close?
- If you process accruals before period close, would this ideally occur on the same date every month, or does it vary?
If there's any other context you want to provide not prompted by the above questions, feel free to include it -- any insight would be greatly appreciated!
Comments
@Jeremy Boniface, I hope just copying and replying to your question here is okay. Here is my response:
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome@tylerzoll thanks for your input!
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome@Jeremy Boniface - here is our Company's response to your questions:
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome@Aussiebandit Thanks for your responses!
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome@Jeremy Boniface, I think I like @Aussiebandit 's answer to question number five more than mine. That would be really helpful to plug in an accrual for all unsubmitted reports.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeAgreed with the comments from Aussiebandit and Tylerzoll but we use Xero.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeHi there -
Which accounting system are you using? Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)? Quickbooks online
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient? line item detail is important, including the employee name (so that we can figure the department). **
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging? **We like to reconcile our credit card liability at the end of the period to the statement. So, we accrue for all credit card transactions.
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting? We use clearing accounts
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close? monthly
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary? continually improving our processes, so it varies.
Additional information: Getting people to do their expenses on time is a never-ending battle. So, my challenge with expense reporting softwares has been getting a complete list of all unapproved credit card transactions to accrue for. If the employee has submitted the expense for approval but it's not yet approved, I should be able to get expense category (e.g. if the employee bucketed it as 'meals expense') and the status of the expense (submitted but not approved).
Further, once we have closed the books, the accounting software will not let expensify post transactions to that month. If an employee has an expense report approved in October for expenses dated in September, what happens? A helpful feature would be to have an option to close the books for September within Expensify. Once we close September period in Expensify, any transactions for September and prior would then be posted on the earliest open date (October 1).
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome@jonpepper Thanks for joining the conversation! We're going to reach out via email to discuss the other topics you mentioned in your response!
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWhich accounting system are you using? Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)? NetSuite and yes, we use the auto-reversal feature for our accruals.
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient? Line-item detail would be preferred.
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging? Airfare, lodging, and meals
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting? AP
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close? Before period close
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary? Around the same date every month but it is not exact
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWhich accounting system are you using? NetSuite Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)? Yes - we use future dated auto reverse on occasion, but not always.
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient? Line item detail would be preferable, and we'd need to have the information on who's expense report is being accrued for.
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging? We book for all categories, unless it would gross up both assets and liabilities (for example a prepaid expense in an expense report)
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting? We use an accrued expense account-would be nice if we could indicate which account we want used for the accrual.
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close? We only book accruals at monthend close, and we do not book accruals for assets (for example, if there is a 1000 airfare for January in December, we would not accrue a prepaid expense, so would need to delete line items from an export if it would be grossing up assets and liabilities
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary? NA for my company
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeAlso, would need to be able to determine the date the accrual is being booked - if a report is not complete or approved and is for a month closed, NetSuite will kick out an error if a JE is dated for a report for a period already closed.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWhich accounting system are you using? Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)?
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient?
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging?
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting?
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close?
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary?
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome- QuickBooks Online and Desktop: we either do nothing or manual journal entries.
- A sum of unpaid totals would be a nice start. The more detail, the better so line item could be helpful, although somewhat inaccurate until a report is submitted and reviewed for approval
All categories
Clearing accounts
Monthly
Most likely when books close which varies by customer
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeHI we use QBO. Our staff who enter their expenses in Expensify, and their supervisors who approve those expenses, are not financially savvy enough to understand accruals, so I wouldn't want to confuse them by giving them the option of choosing an accrual account for their expenses. Each expenses claim is auto-uploaded to QBO when it is approved, and I always check the JE that has been auto-generated and make any necessary adjustments.
However if Expensify has an automatic accrual function based on the date of the receipt, and staff can't see this when they log or approve expenses, I would be interested in exploring this further.
We book accruals and pre-payments monthly.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome1) Which accounting system are you using? Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)?
Sage Intacct. Auto-reversing entries.
2) What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient?
Sum of unpaid incurred totals per GL by department tag would be sufficient
3) Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging?
We book accruals whenever the amount is material - over a certain dollar amount
4) Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting?
Unsure
5) How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close?
just before period close
6) If you process accruals before period close, would this ideally occur on the same date every month, or does it vary?
date varies
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeI haven't read the all detail.
Our accounting system is Xero.
We use Expensify for employees reimbursable expenses and the company credit cards for non-reimbursable expenses.
For accruals, at a chosen date it would be useful to total all open and processing reports and accrue for them through Xero's API integration.
There should be two accruals reimbursable and non-reimbursable.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWhich accounting system are you using?**Intacct **
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient? line Item detail
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging?All categories
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting?we use auto reversing entries
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close?Period close
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary?It varies
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeAre you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)?** No.**
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient? Total per GL would be sufficient in most cases.
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging? Very few accruals.
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting? AP account.
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close? Monthly.
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary? Same date every month.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWhich accounting system are you using? Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)?
Sage Intacct
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient?
All detail would be better. If this feature were available, I would take an excel export from Expensify & turn it into a JE csv upload for Intacct. I'd manually review and sum by GL since sometimes we have employees making purchases for other departments.
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging?
All but I don't usually have a lot of expense accruals because I do a lot of nagging around moth close.
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting?
We use a clearing account.
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close? Monthly.
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary? We do not.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWhich accounting system are you using? Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)? NetSuite and Yes
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient? Summary level by GL and Department would be enough for us
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging? All categories
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting? One AP account
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close? Just before period close
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary? Accruals typically happen on day 2 or 3 of the close process, so roughly on the same day every month.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWe use Quickbooks, I would say I would answer just as Jonpepper did to the questions.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWhich accounting system are you using? Netsuite
Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)? Yes, future dated auto reversal. Sometimes we use an amortization to allocate prepaid expenses.
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient? detail would be needed
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging? all accounts
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting? one Accrued Liabilities account
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close? just when we close our monthly books
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary? N/A
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome1) Which accounting system are you using? Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)? Quickbooks Online. Yes.
2) What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient?
Currently, we require line-item detail. **
3) Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging?
**All categories
4) Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting?
A clearing account designated specifically for accruals
5) How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close?
Only for the monthly period close
6) If you process accruals before period close, would this ideally occur on the same date every month, or does it vary?
N/A
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWhich accounting system are you using? Sage Intacct
Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)?
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient? The more detail the better (merchant, date, amount
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging?All
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting?Yes
How often do you need to book your accrual entries? Would this be something you want totaled and booked daily, weekly, or just before period close?Weekly would be nice
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary?Month end, but that date varies depending on days in a month, when the weekend hits, etc.
If there's any other context you want to provide not prompted by the above questions, feel free to include it -- any insight would be greatly appreciated!
Additional insight on jonpepper's response I absolutely agree with, not allowing a date of September to be used once September is closed but automatically having it go to Oct 1 would be really helpful. **Also a streamline way to know what reimbursements are still outstanding like being able to filter and print a report by the confirmed date, not the date the reimbursement was initiated **
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWe would also like to see a report in Expensify that would allow us to quickly retrieve a list of expenses that are not yet posted to NetSuite (whether reported yet or not). The loading dock reports only give us "Unreported Expenses" or "All Expenses". We need something in between that includes the expenses that have been reported, but only if they are still pending approval or reimbursement.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeThanks for asking for feedback.
Which accounting system are you using? Quickbooks online
Are you leveraging any native features on the accounting end to streamline the process (ie. future-dated auto-reversal)? Sometimes, but not much (yet).
What level of detail do you need to effectively book your accruals? Would line-item detail (merchant, date, amount) be absolutely necessary, or would a sum of unpaid incurred totals per GL be sufficient? Line item and/or total by account code
Do you typically book accruals for all categories, or only for high risk accounts, like Meals and Lodging? accurals for most categories that are material and we can reasonably predict something outstanding exists.
Do you use a clearing account for your accruals, or do you use one AP account to handle all expense reporting? couple different clearing accounts
How often do you need to book your accrual entries? Monthly at most
Would this be something you want totaled and booked daily, weekly, or just before period close? available on demand
If you process accruals before period close, would this ideally occur on the same date every month, or does it vary? varies
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeNetSuite. We regularly use the amortization by line item feature on bills to generate the journal entries (and reversing ones) going forward.
We need line-item detail.
All categories.
We have an Accrued Expenses clearing account.
Expensify can only post to one AP account for expense reporting per the NetSuite sync.
We do it on demand. Reports can be run any day. I don't think we would want to have to wait to see the current accruals.
Varies--see answer 5.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeOur situation is very similar to jonpepper's above. The issue with expenses from one month that are approved in the next month is an important issue for us as well.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome