Is there a way to create a multi-line report?

For example, my accounting system needs to multi-line import, so I'd like to make the export from Expensify in that manner. For example: Line 1:Employee 1, Report Date, Amount, Description; Line 2: GL Code, Date, Description, Amount. I've been unable to find a way to do this within the report set up instructions.
Thanks in advance!
Thanks in advance!
Tagged:
Answers
Each of these exports will email you the report in a CSV file.
If you'd instead like to build your own custom export, check out our Export Custom Reports Guide! You can create custom exports under your Settings > Account > Preferences > CSV Export Formats. This template will be available to the user on whose account it was created. If you need a custom export template that can be shared among all policy admins, this feature is available on the Control plan.
Let me know if you have any more questions about this!
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeThanks for the response. That's not what I'm looking for. My accounting system requires two rows per expense to be imported, not columns, so I was hoping to find a way to export it into rows. For example:
Employee A, Expense Date, Expense Description
GL Code, Merchant, Attendees
I'd also like to be able to total by employee by category, but that's unavailable within Expensify custom reports as well, and the Category level you have to run by individual employee, which is kind of frustrating, as the report does not indicate what employee it's for either. If the capability for the reporting is there, I don't understand why it's not available to everyone to use in a custom report.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeAs for viewing employee totals by categories, while logged into the web app, you can see expense analytics by going to the Expenses page and clicking the Pie Chart icon located in the View section in the upper right corner. This will allow you to filter by employee and then view totals by category. You can learn more about the Expenses page filters & analytics in this help article.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeRe: categories by employee - I know that. I don't understand why it's not something that can be done within one file for all employees. It seems like the capabilities are there, but not yet fully developed. I have already submitted this as an idea.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeThanks as well for adding your idea regarding categories by employee, that's the best step you can take to getting a change made. We review the ideas shared frequently and the Success Team advocates for the ideas that are most popular.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome