[GNC] Merge two pairs -> one 4-way split
Justin Vallon
justinvallon at gmail.com
Mon Jan 23 17:58:30 EST 2023
Maybe unrelated, but when entering reimbursable transactions, I enter a
second transaction to indicate a reimbursable expense. Mostly so I don't
lose it.
For example:
Day1 Doctor Visit - Copay
Amex -20
Doc +20
FSA Funds -20
Memo: DocVisitDay1 FSA Unclaimed +20
Now, I have an FSA Unclaimed account with non-zero balance. Since there
is a non-zero balance there, I need to enter some claims. When I enter
the claim:
Day2 Submit claim
Memo: DocVisitDay1 FSA Unclaimed -20
Memo: DocVisitDay1 FSA Submitted +20
If I don't have the "FSA" account on the original visit, it becomes
difficult to locate that original Doctor Visit transaction, since it is
in a different account. Or, I would need to make sure that I
simultaneously enter the Copay entry and submit the insurance claim,
otherwise I might lose track of the original expense that I need to submit.
This is from the GNUCash manual:
https://www.gnucash.org/docs/v4/C/gnucash-guide/accts-oa5.html -
reimbursable expenses, travel advances
For example, when you use your personal card on a business trip, you
enter CreditCard -X, Dining +X and Employer -X, Reimbursable +X in the
same transaction. At the end of the trip, submit all Reimbursable
entries, and wait for a check from your employer. The check is entered
as Reimbursable -X, Checking +X.
For an out-of-network doctor:
Day1 DocVisit Medical +200
Doc +200
Day1 DocPay Amex -200
Doc +200
Medical -200
Unclaimed +200
Day2 Submit DocVisit to insurance Unclaimed -200
Claimed +200
Day20 EOB Claimed -200
Covered 75% Covered +150
Copay, etc Uncovered +50
Uncovered -50
FSA Unclaimed +50
Day21 Insurance Check Covered -150
Checking +150
Day22 FSA Submit FSA Unclaimed -50
Submitted +50
Day25 FSA Approved Submitted -50
Approved +50
Day28 FSA Reimburse Approved -50
Checking +50
You can shorten some of these A>B>C transfers, but since the processing
period is sometimes weeks, the dates on the doctor visit, insurance
check, and FSA reimburse might be days or weeks apart. The date of the
Insurance check deposit should correspond to the deposit date, not the
doctor visit date; same for the FSA reimbursement.
-Justin
On 1/15/23 3:46 PM, Phyllis Bruce wrote:
> I agree, why change them. However, I question the need to make a single 4
> way split unless one of the transactions is to or from a single account.
>
> On Sun, Jan 15, 2023 at 1:51 PM Fred Tydeman <tydeman.fred at gmail.com> wrote:
>
>> I have one transaction moving money from A to B (one pair)
>> I have another transaction moving money from C to D (another pair)
>> I now realize I should have one transaction with 4 splits.
>> Is there an easy way to merge the two pairs into one 4-way split?
>> Or, do I have to manually re-enter 40 transactions?
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
More information about the gnucash-user
mailing list