plaintextaccounting.org

Multiple currencies

Paypal conversions, reimbursements

A complicated real-life example (try to avoid this). Here were several ways of recording a situation involving

Short version

A pragmatic condensed version. The foreign currency and paypal transactions are noted only as comments, and don't appear in reports. The client reimbursement balance is reported as $ (appropriate in this case since they were billed in dollars).

2022-03-16 * mail-tester.com | for client
    ;  txnid:6J734837CW8252237, paypal outflow
    ;  txnid:6T5967442S085784Y, refill from checking
    ;  txnid:5U407731S97694332, convert from €
    ;  txnid:7GR54150TH923981E, convert to $
    JS:assets:receivable:cl:reimbursement         $5.74  ; for €5.00 mail-tester expense
    sm:assets:bank:wf:pchecking                 $ -5.74
    ; note business obligation to repay personal account
    JS:liabilities:payable:sm:reimbursement      $-5.74
    sm:assets:receivable:JS:reimbursement         $5.74

register

2022-03-16 mail-tester.com | for client             JS:assets:receivable:cl:reimbursement            $5.74         $5.74
                                                    sm:assets:bank:wf:pchecking                     $-5.74             0
                                                    JS:liabilities:payable:sm:reimbursement         $-5.74        $-5.74
                                                    sm:assets:receivable:JS:reimbursement            $5.74             0

balance -E

               $5.74  JS:assets:receivable:cl:reimbursement
              $-5.74  JS:liabilities:payable:sm:reimbursement
              $-5.74  sm:assets:bank:wf:pchecking
               $5.74  sm:assets:receivable:JS:reimbursement
--------------------
                   0  

Compact version

The foreign currency was recorded, using @@ notation. The client reimbursement balance is reported in the foreign currency, needing -B or similar to convert to $. The paypal transactions are noted only as comments.

2022-03-16 * mail-tester.com | for client
    ; paypal purchase, drawn from checking
    ;  txnid:6J734837CW8252237, paypal outflow
    ;  txnid:6T5967442S085784Y, refill from checking
    ;  txnid:5U407731S97694332, convert from €
    ;  txnid:7GR54150TH923981E, convert to $
    JS:assets:receivable:cl:reimbursement         €5.00 @@ $5.74
    sm:assets:bank:wf:pchecking                  $-5.74
    ; note business obligation to repay personal account
    JS:liabilities:payable:sm:reimbursement      $-5.74
    sm:assets:receivable:JS:reimbursement         $5.74

register

2022-03-16 mail-tester.com | for client             JS:assets:receivable:cl:reimbursement            €5.00         €5.00
                                                    sm:assets:bank:wf:pchecking                     $-5.74        $-5.74
                                                                                                                   €5.00
                                                    JS:liabilities:payable:sm:reimbursement         $-5.74       $-11.48
                                                                                                                   €5.00
                                                    sm:assets:receivable:JS:reimbursement            $5.74        $-5.74
                                                                                                                   €5.00

balance -E

               €5.00  JS:assets:receivable:cl:reimbursement
              $-5.74  JS:liabilities:payable:sm:reimbursement
              $-5.74  sm:assets:bank:wf:pchecking
               $5.74  sm:assets:receivable:JS:reimbursement
--------------------
              $-5.74
               €5.00  

Detailed version

A fully detailed version. Equity is used for balanced currency conversions. All transactions from paypal's CSV are included (generated by conversion rules).

2022-03-16 * mail-tester.com | for client
    ; txnid:6J734837CW8252237, itemid:, fromemail:, toemail:[email protected], type:T0007, status:S
    sm:assets:online:paypal                      €-5.00 =* €-5.00
    JS:assets:receivable:cl:reimbursement         €5.00

2022-03-16 * T0300 for 6J734837CW8252237 Total price
    ; txnid:7GR54150TH923981E, itemid:, fromemail:, toemail:, type:T0300, status:S
    sm:assets:online:paypal                      $ 5.74 =* $ 5.74
    sm:assets:bank:wf:pchecking                 $ -5.74

2022-03-16 * T0200 for 6J734837CW8252237 Total price
    ; txnid:6T5967442S085784Y, itemid:, fromemail:, toemail:, type:T0200, status:S
    sm:assets:online:paypal                     $ -5.74 =* $ 0.00
    JS:equity:conversion                         $ 5.74

2022-03-16 * T0200 for 6J734837CW8252237 Total price
    ; txnid:5U407731S97694332, itemid:, fromemail:, toemail:, type:T0200, status:S
    JS:equity:conversion                         €-5.00
    sm:assets:online:paypal                       €5.00 =* €0.00

2022-03-16 * note business obligation to repay personal account
    JS:liabilities:payable:sm:reimbursement      $-5.74
    sm:assets:receivable:JS:reimbursement         $5.74

2022-03-16 * convert cl receivable from 6J734837CW8252237
    JS:assets:receivable:cl:reimbursement        €-5.00
    JS:equity:conversion                          €5.00
    JS:equity:conversion                         $-5.74
    JS:assets:receivable:cl:reimbursement         $5.74

register

2022-03-16 mail-tester.com | for client             sm:assets:online:paypal                         €-5.00        €-5.00
                                                    JS:assets:receivable:cl:reimbursement            €5.00             0
2022-03-16 T0300 for 6J734837CW8252237 Total price  sm:assets:online:paypal                         $ 5.74        $ 5.74
                                                    sm:assets:bank:wf:pchecking                    $ -5.74             0
2022-03-16 T0200 for 6J734837CW8252237 Total price  sm:assets:online:paypal                        $ -5.74       $ -5.74
                                                    JS:equity:conversion                            $ 5.74             0
2022-03-16 T0200 for 6J734837CW8252237 Total price  JS:equity:conversion                            €-5.00        €-5.00
                                                    sm:assets:online:paypal                          €5.00             0
2022-03-16 note business obligation to repay per..  JS:liabilities:payable:sm:reimbursement        $ -5.74       $ -5.74
                                                    sm:assets:receivable:JS:reimbursement           $ 5.74             0
2022-03-16 convert cl receivable from 6J734837CW..  JS:assets:receivable:cl:reimbursement           €-5.00        €-5.00
                                                    JS:equity:conversion                             €5.00             0
                                                    JS:equity:conversion                           $ -5.74       $ -5.74
                                                    JS:assets:receivable:cl:reimbursement           $ 5.74             0

balance -E

              $ 5.74  JS:assets:receivable:cl:reimbursement
                   0  JS:equity:conversion
             $ -5.74  JS:liabilities:payable:sm:reimbursement
             $ -5.74  sm:assets:bank:wf:pchecking
                   0  sm:assets:online:paypal
              $ 5.74  sm:assets:receivable:JS:reimbursement
--------------------
                   0  

See also


(c) 2016-2024 Simon Michael & contributors | Send updates via github