cash basis income statement on saved search. Has a...
# accounting
s
cash basis income statement on saved search. Has anyone created one?
r
There's a cash basis option on the out of the box Income Statement report. Does that not work for you?
s
this is not the correct cash basis report. as it includes non cash transactions as well. such as depreciation expense and deferred revenue/expense. Im trying to create a cash basis income statement on saved search
a
I had a client in this situation, we added a checkbox to transactions "exclude from cash basis reports" then customised the P&L to filter out such transactions. Of course for this to work, you need to have users who will use the checkbox, or some way to automatically identify relevant transactions...
💡 1
k
create custom cash flow statement. Saved search does really work well imo
s
@Karina can you please share details on the saved search? how did you create it?
the issue with my saved search is that non cash journals keep showing. how did you exclude those?
k
you MUST have your list of accounts specific to each cash flow statement line. This list comes from your controller. I found creating a custom cash flow statement in reports is easier than creating one in Analytics (not exactly a saved search). After trying both I recommend using reports
if you have to de-select journals I do not have the way to make it work :(
s
thanks Karina
👍🏻 1