NPO-Accounting/conservancy_beancount Files · tests/books/accruals.beancount

Files @ 7441f4ef0ce1

Branch filter:

Location: NPO-Accounting/conservancy_beancount/tests/books/accruals.beancount

7441f4ef0ce1 4.9 KiB text/plain Show Annotation Show as Raw Download as Raw

Brett Smith

ledger: Correct period totals. RT#11661.

The period totals were reporting the balance of all the loaded postings, not
just the ones in the reporting date range.

Like the accrual report, introduce a RelatedPostings subclass that records
and saves all the information we need at group definition time, to help us
get it consistently right rather than redoing the same math over and over.

2010-01-01 open Assets:Checking
2010-01-01 open Assets:Receivable:Accounts
2010-01-01 open Expenses:FilingFees
2010-01-01 open Expenses:Services:Legal
2010-01-01 open Expenses:Travel
2010-01-01 open Income:Donations
2010-01-01 open Liabilities:Payable:Accounts
2010-01-01 open Equity:Funds:Opening

2010-03-01 * "Opening balances"
  Equity:Funds:Opening  -1000 USD
  Assets:Receivable:Accounts  6000 USD
  Liabilities:Payable:Accounts  -5000 USD

2010-03-05 * "EarlyBird" "Payment for receivable from previous FY"
  rt-id: "rt:40"
  invoice: "rt:40/400"
  project: "Conservancy"
  Assets:Receivable:Accounts  -500 USD
  Assets:Checking  500 USD

2010-03-06 * "EarlyBird" "Payment for payment from previous FY"
  rt-id: "rt:44"
  invoice: "rt:44/440"
  project: "Conservancy"
  Liabilities:Payable:Accounts  125 USD
  Assets:Checking  -125 USD

2010-03-15 * "GrantCo" "2010Q1 grant"
  rt-id: "rt:470"
  invoice: "rt:470/4700"
  project: "Development Grant"
  Assets:Receivable:Accounts  5000 USD
  Income:Donations           -5000 USD

2010-03-25 * "GrantCo" "2010Q1 grant ACH payment"
  rt-id: "rt:470"
  invoice: "rt:470/4700"
  project: "Development Grant"
  Assets:Receivable:Accounts  -5000 USD
  Assets:Checking              5000 USD

2010-03-30 * "EarlyBird" "Travel reimbursement"
  rt-id: "rt:490"
  invoice: "rt:490/4900"
  project: "Conservancy"
  Liabilities:Payable:Accounts  -75 USD
  Expenses:Travel  75 USD

2010-04-15 * "Multiparty invoice"
  rt-id: "rt:480"
  invoice: "rt:480/4800"
  project: "Conservancy"
  Expenses:Travel  250 USD
  Liabilities:Payable:Accounts  -125 USD
  entity: "MultiPartyA"
  Liabilities:Payable:Accounts  -125 USD
  entity: "MultiPartyB"

2010-04-18 * "MultiPartyA" "Payment for 480"
  rt-id: "rt:480"
  invoice: "rt:480/4800"
  project: "Conservancy"
  Liabilities:Payable:Accounts  125 USD
  Assets:Checking  -125 USD

2010-04-20 * "MultiPartyB" "Payment for 480"
  rt-id: "rt:480"
  invoice: "rt:480/4800"
  project: "Conservancy"
  Liabilities:Payable:Accounts  125 USD
  Assets:Checking  -125 USD

2010-04-25 ! "Vendor" "First trip travel reimbursement"
  rt-id: "rt:310"
  contract: "rt:310/3100"
  invoice: "FIXME"  ; still waiting on them to send it
  project: "Conservancy"
  Liabilities:Payable:Accounts  -200 USD
  Expenses:Travel  200 USD

2010-04-30 * "Vendor" "Second trip travel reimbursement"
  rt-id: "rt:310"
  contract: "rt:310/3100"
  invoice: "rt:310/3120"
  project: "Conservancy"
  Liabilities:Payable:Accounts  -220 USD
  Expenses:Travel  220 USD

2010-05-05 * "DonorA" "Donation pledge"
  rt-id: "rt:505"
  invoice: "rt:505/5050"
  approval: "rt:505/5040"
  project: "Conservancy"
  Income:Donations  -2,500 EUR {1.100 USD}
  Assets:Receivable:Accounts  2,500 EUR {1.100 USD}

2010-05-10 * "Lawyer" "April legal services"
  rt-id: "rt:510"
  invoice: "rt:510/5100"
  contract: "rt:510/4000"
  project: "Conservancy"
  Expenses:Services:Legal  200.00 USD
  Liabilities:Payable:Accounts  -200.00 USD

2010-05-15 * "MatchingProgram" "May matched donations"
  invoice: "rt://ticket/515/attachments/5150"
  approval: "rt://ticket/515/attachments/5140"
  project: "Conservancy"
  Income:Donations  -1500.00 USD
  Assets:Receivable:Accounts  1500.00 USD

2010-05-20 * "DonorA" "Donation made"
  rt-id: "rt:505"
  invoice: "rt:505/5050"
  project: "Conservancy"
  Assets:Receivable:Accounts  -2,750.00 USD
  Assets:Checking  2,750.00 USD
  receipt: "DonorAWire.pdf"

2010-05-25 * "Lawyer" "May payment"
  rt-id: "rt:510"
  invoice: "rt:510/5100"
  project: "Conservancy"
  Liabilities:Payable:Accounts  200.00 USD
  contract: "rt:510/4000"
  Assets:Checking  -200.00 USD
  receipt: "rt:510/5105"

2010-06-10 * "Lawyer" "May legal services"
  rt-id: "rt:510"
  invoice: "rt:510/6100"
  contract: "rt:510/4000"
  project: "Conservancy"
  Expenses:Services:Legal  220.00 USD
  Liabilities:Payable:Accounts  -220.00 USD

2010-06-12 * "Lawyer" "Additional legal fees for May"
  rt-id: "rt:510"
  invoice: "rt:510/6100"
  contract: "rt:510/4000"
  project: "Conservancy"
  Expenses:FilingFees  60.00 USD
  Liabilities:Payable:Accounts  -60.00 USD

2010-06-15 * "GrantCo" "2010Q2 grant"
  rt-id: "rt:470"
  invoice: "rt:470/4700"
  project: "Development Grant"
  Assets:Receivable:Accounts  5500 USD
  Income:Donations           -5500 USD

2010-06-18 * "EuroGov" "European legal fees"
  ; Multiple rt-ids are used to test proper handling for both
  ; searching and generating the outgoing report.
  rt-id: "rt:520 rt:525"
  invoice: "rt:520/5200"
  contract: "rt:520/5220"
  project: "Conservancy"
  Liabilities:Payable:Accounts  -1,000 EUR {1.100 USD}
  Expenses:FilingFees  1,000 EUR {1.100 USD}

2010-06-20 * "StateGov" "Business registration"
  ; Intentionally has no rt-id
  invoice: "Invoices/2010StateRegistration.pdf"
  project: "Conservancy"
  Liabilities:Payable:Accounts  -50 USD
  Expenses:FilingFees  50 USD

2010-09-15 * "GrantCo" "2010Q3 grant"
  rt-id: "rt:470"
  invoice: "rt:470/4700"
  project: "Development Grant"
  Assets:Receivable:Accounts  6000 USD
  Income:Donations           -6000 USD