How to handle expense checks that include per-diem

Andrew Sackville-West andrew at swclan.homelinux.org
Wed Nov 7 02:04:35 EST 2007


Please be sure to reply to the list.

On Tue, Nov 06, 2007 at 05:22:26PM -0800, Bill Michal wrote:
> So, when I deposit into CC, from Asset:Reimb, then I can pay down the
> liabilities from checking.  Correct?
> 


I'm never good with these terms, so I'll try to draw it out. 

In youre credit card account register, enter a transaction like this:
Date	 Description	     Account	     Payment    Charge   Balance
1/1/07	 work expenses	     Asset:reim.		10.00	 10.00

this is for the work related, reimburseable expense paid with your
personal credit card. From the other side of the transaction, in
Asset:reim. it looks like this:

Date	Description	  Account	Increase    Decrease   Balance
1/1/07	work expenses	  Liability:CC	10.00		       10.00

Now, your credit card comes due but you haven't been reimbursed yet,
so you pay the credit card bill, like this from your checking account

Date     Description	   Accoutn     Deposit  Withdrawal  Balance
1/20/07  Pay credit card  Liability:CC		10.00	    -10.00

which makes credit card register look like this:
Date	 Description	     Account	     Payment    Charge   Balance
1/1/07	 work expenses	     Asset:reim.		10.00	 10.00
1/20/07  Pay credit card     Asset:checking  10.00		 0.00

Then a few days later, the company reimburses you with a check, which
you deposit in you're checking account which now looks like this:

Date     Description	   Accoutn     Deposit  Withdrawal  Balance
1/20/07  Pay credit card  Liability:CC		10.00	    -10.00
1/25/07  reimbursement!   Asset:reim.  10.00		    0.00

which makes the Asset:reim. account register look like this:

Date	Description	  Account	Increase    Decrease   Balance
1/1/07	work expenses	  Liability:CC	10.00		       10.00
1/25/07 reimbursement!	  Asset:checking             10.00     0.00

that completes the whole thing. notice that each accounts up back at
zero. This is as it should be because you are only a conduit for this
money to pass through. Its not your money or expenses, it is the
company's. You are only a temporary resting point for it on it
journey. 

I hope the pictures came through okay.

note also that these transactions can happen in any order. For
example, the company could know in advance that you're going to spend
$10.00 for them and give you the money in advance, which you would
handle in exactly the same way. The key is that all the accounts it
touches get back to wear they started.

A


> -----Original Message-----
> From: gnucash-user-bounces at gnucash.org
> [mailto:gnucash-user-bounces at gnucash.org] On Behalf Of Andrew
> Sackville-West
> Sent: Tuesday, November 06, 2007 4:58 PM
> To: gnucash-user at gnucash.org
> Subject: Re: How to handle expense checks that include per-diem
> 
> On Tue, Nov 06, 2007 at 04:38:00PM -0800, Bill Michal wrote:
> > Thanks
> > 
> > I've been thinking about this.  I can understand that the expenses are
> > owed to me, but I still have a liability on my credit card for the
> > costs.  When I enter a transaction in Assets:Reimbursable, do I put
> > Liabilities:Credit Card on the line?
> > 
> > Also, I will be transferring from Checking to Liabilities:Credit Card
> to
> > pay off the card balance before I receive the reimbursement check.
> Your
> > comment seems to say that I deposit the reimbursement check into
> > Assets:Reimbursable.
> 
> close. when you deposit the reimbursement check into your checking
> account, the money for that check comes from
> Assets:Reimbursement. That is the other side of the split from
> checking account will be Assets:Reimb.  That wil complete the
> circle. its a three part circle. Each of the three parts can be
> completed at any time so long as all three get done. 
> 
> $ from CC to asset:Reim.
> $ from checking to CC
> $ from asset:reim to checking. 
> 
> the money owed to you is an asset, as is your checking account. The
> repayment of that money owed to you (reimbursement) is simply
> transferring that asset from one asset account to another: from a form
> you can't really use to one you can use. 
> 
> make sense?
> 
> A
> > 
> > -----Original Message-----
> > From: gnucash-user-bounces at gnucash.org
> > [mailto:gnucash-user-bounces at gnucash.org] On Behalf Of Andrew
> > Sackville-West
> > Sent: Friday, November 02, 2007 12:54 PM
> > To: gnucash-user at gnucash.org
> > Subject: Re: How to handle expense checks that include per-diem
> > 
> > On Fri, Nov 02, 2007 at 08:49:43AM -0700, Bill Michal wrote:
> > > Hello,
> > > 
> > >  
> > > 
> > > I would like to run an idea past the experts.  I have expenses
> related
> > to
> > > travel for my employer (airfare, hotel, car rental, cell phone, .)
> > plus I
> > > receive a per-diem for each day I travel.  I created a new account
> > called
> > > Expenses:Work to record these specific expenses and a new account
> > called
> > > Income:Reimbursement to record expense checks.  My idea was that
> when
> > I
> > > received an expense check, record it in Income:Reimbursement then
> > transfer
> > > an amount equal to the current balance of expenses (or all of it if
> > expense
> > > total exceeds check).  Any balance in Income:Reimbursement is
> > transferred to
> > > Income:Checking Account.
> > > 
> > >  
> > > 
> > > Does that sound right?
> > 
> > not to me. I would create an asset account called "Reimburseable
> > expenses" or some such. When I make a work related expense, it would
> > be a transfer to that asset account. Then when I get reimbursed, it
> > would likewise be transfered to that account. The theory is that money
> > owed to you is an asset. Money you pay on behalf of your employer
> > increases the value of that asset. Money paid to you by your employer
> > as a reimbursement reduces the value of that asset.
> > 
> > At some point you have to deal with that account, if yoiu have
> > recieved money in excess of what you are owed, then at some point you
> > either have to pay it back, or write it off as income. LIkewise if you
> > never get reimbursed for some expense, then you write it off as an
> > expense later. 
> > 
> > hopefully, that makes sense, and I understood your question.
> > 
> > A
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > 
> 
> -- 
> 

-- 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20071106/31f78dad/attachment.bin 


More information about the gnucash-user mailing list