How to make proper reporting for a traveling ?

  • 0
  • 1
  • Question
  • Updated 2 weeks ago
  • Answered
I travel regularly to different places. I would like to see a report per each place  (Florida_NOV18/NY_Dec18/etx (including categories (tickets. hotels etc). If I would use tags for it, after a few years there will be too many. What else can I use for my task? 
Photo of Alexander

Alexander

  • 168 Points 100 badge 2x thumb

Posted 2 weeks ago

  • 0
  • 1
Photo of Andrew

Andrew

  • 2,880 Points 2k badge 2x thumb
That's what I do (use TAGs).  Whatever scheme you pick to differentiate your trips will have some different value that the others, so I don't see how you get around this. I'll be following this to see if others have any ideas.
Photo of Bob L

Bob L, SuperUser

  • 109,482 Points 100k badge 2x thumb
Using tags is what I recommend, though I would just tag the location as transaction date already distinguishes differences. That would also help with your “too many” issue.
(Edited)
Photo of Alexander

Alexander

  • 168 Points 100 badge 2x thumb
Thank you!  Seems to me that a tag is the only solution 
Photo of Jim Harman

Jim Harman, SuperUser

  • 30,750 Points 20k badge 2x thumb
Also if your tag list gets long you can hide the ones you are no longer using for new transactions. You can also delete tags if you will not be using them for future reports. Per the Help,
When you hide a tag you declutter your Tag List, but you can just show it again if you ever need to use it in the future.

When you permanently delete a tag, Quicken removes it from the Tag list and from the Tag field of any transactions to which it has been assigned. You lose the ability to use the tag in future reports.
Photo of Alexander

Alexander

  • 168 Points 100 badge 2x thumb
Thank you!  
Photo of q.lurker

q.lurker, SuperUser

  • 276,174 Points 100k badge 2x thumb
Tags are the best solution.  I would consider separate tags for destination and 'year' to reduce the tag-clutter -- Florida, NY, CA, 2018, 2019, etc.  You may have expenses for the 2019 trip that you paid for in 2018.  Travel/FL:2018, Hotel/NY:2017
Photo of Alexander

Alexander

  • 168 Points 100 badge 2x thumb
this is a great addition! Thank you!  
Photo of Andrew

Andrew

  • 2,880 Points 2k badge 2x thumb
What I do is use a combination of the year (first!) and locale, like "2017 Turkey", "2018 Asia", etc. That way the list is sorted numerically and the most recent trips are at the bottom. Makes it easier for me to pick the right one. Just one man's method.
(Edited)
Photo of Alexander

Alexander

  • 168 Points 100 badge 2x thumb
Thank you!  
Photo of NotACPA - QW HBRP 2019

NotACPA - QW HBRP 2019, SuperUser

  • 378,956 Points 100k badge 2x thumb
Alexander,
Are these reimbursable expenses?  Will your employer repay them?  OR, are they going onto your Schedule C "Profit or Loss from Business".

I ask because there's another accounting option available if the expenses are reimbursable.
Photo of Alexander

Alexander

  • 168 Points 100 badge 2x thumb
no, they are not reimbursable. But I am curious to learn other options for the future :) 
Photo of NotACPA - QW HBRP 2019

NotACPA - QW HBRP 2019, SuperUser

  • 378,956 Points 100k badge 2x thumb
The other option is to create a Receivables, asset-type, account and post all of the expenses as transfers to that account.   THEN, when you get reimbursed, you show the reimbursement deposit into your banking account as a transfer FROM the Receivables account.

Using this technique, you can periodically reconcile the receivables account (which would normally be to $0 after the reimbursement).  Anything not yet reconciled would be still owed to you by the employer.

Also note that this doesn't have to be "employer  receivables" ... because I use the same technique for the amount that I've loaned to my brother.

Tags CAN be used to track things, in this scenario, but really aren't necessary because the expenses, and reimbursement, aren't taxable ... and thus don't need the same level of detail.
Photo of Alexander

Alexander

  • 168 Points 100 badge 2x thumb
interesting option. will try. Thank you!  

This conversation is no longer open for comments or replies.