73 posts tagged with "accounting"

Hand-stitched ledgers beat tangled spreadsheets—especially when every cent counts.

For the artists, makers, and curators on Etsy, passion drives the business. But as your shop grows, financial clarity becomes just as important as creative vision. Juggling fees, tracking material costs, and preparing for taxes can feel overwhelming, pulling you away from the workbench.

What if you could manage your shop’s finances with the same care and precision you put into your products? This guide introduces a plain-text accounting workflow using Beancount, an open-source engine designed for accuracy and control. It’s a method that helps you master your numbers so you can focus on your craft.

Why Etsy Bookkeeping Is Different​

An Etsy shop has a unique financial fingerprint, with complexities that generic accounting software often misses.

• Marketplace fees everywhere: Your final payout is what's left after Etsy takes its share. Listing fees, transaction fees, payment processing fees, and advertising costs all nibble away at every sale. Without tracking them individually, you can't know your true profit margins.
• Platform-controlled sales tax: In a huge win for sellers, Etsy now automatically calculates, collects, and remits sales tax on your behalf in most states. However, if you sell on other channels or have a physical presence in certain states, you might still have your own sales tax obligations due to "nexus" rules.
• Flexible payout cadence: Depending on your settings and account history, Etsy can deposit your funds daily, weekly, bi-weekly, or monthly. This flexibility can make cash flow feel unpredictable, especially when funds are held in reserve or delayed. (Etsy Help)
• Lower 1099-K thresholds: The days of flying under the tax radar are over. The IRS reporting threshold for Form 1099-K, which reports your gross sales, is set at $5,000 for 2024 and is planned to drop to just$600 by 2026. This means nearly every shop will receive an IRS form, and your books must be able to reconcile with it perfectly. (IRS)

Beancount Blueprint in Seven Quick Steps​

This plain-text blueprint will help you build a clear, accurate, and stress-free bookkeeping system.

1. Separate Channels Up Front​

If Etsy isn't your only sales channel, create separate income and expense accounts for each one. This simple separation at the top level of your chart of accounts keeps your analytics clean and makes tax time much easier.

2025-07-22 open Income:Etsy               USD
2025-07-22 open Expenses:Etsy:ListingFee   USD
2025-07-22 open Assets:Etsy:Payout         USD

2. Explode Every Payout​

Never record an Etsy deposit as a single line of income. Instead, download your monthly Payment Account CSV from your Shop Manager. Use this report to create a single Beancount transaction that "explodes" each deposit into its gross sales and individual fee components.

; weekly payout from the Etsy Payment Account CSV
2025-07-15 * "Etsy Deposit #2025-28"
  Assets:Bank:Operating             1842.77 USD
  Income:Etsy:Sales               -2100.00 USD
  Expenses:Etsy:TransactionFee        136.50 USD  ; 6.5 %
  Expenses:Etsy:PaymentProcessing      66.00 USD  ; 3 % + $0.25 per order
  Expenses:Etsy:ListingFee             14.00 USD  ; $0.20 x 70 renewals
  Assets:Etsy:Reserve                -75.73 USD

3. Track Inventory & COGS with Lots​

For sellers of physical goods, Beancount's "lots" feature is a game-changer for tracking Cost of Goods Sold (COGS). When you buy raw materials, you record them as inventory at a specific cost. When you sell a finished product, you can expense the exact cost of the materials used.

; Purchase bulk materials for inventory
2025-07-01 * "Bulk yarn purchase | Supplier XYZ"
  Assets:Inventory:ScarfBlue     500 ScarfBlue {@ 3.45 USD}
  Assets:Bank:Operating

; Record the COGS when an item sells
2025-07-20 * "Sold Blue Scarf | Order #1234"
  Expenses:COGS                  1 ScarfBlue {3.45 USD}
  Assets:Inventory:ScarfBlue

4. Pick Your Accounting Method Early​

You have two main choices:

• Cash basis: Simple and easy. You record income when the money lands in your bank and expenses when you pay for them. This works well for small, hobby-scale shops.
• Accrual basis: Provides a truer picture of profitability. You record revenue when you make the sale (not when you get paid) and expenses when you incur them. This is better for shops that buy supplies in bulk or sell made-to-order items.

5. Automate Imports​

Save time by automating data entry. The plain-text ecosystem offers several options:

• Use bean-extract with custom rules to parse the Etsy CSV files.
• Configure a bank CSV importer to catch ad charges or shipping labels paid by credit card.
• For advanced users, write a Python script to pull reports directly from the Etsy API.

6. Reconcile Weekly​

Set aside a few minutes each week to check your numbers. Use Beancount's command-line tools to quickly validate your balances and spot any issues like released reserves, refunds, or fee adjustments before the month ends.

# Check the balance of your Etsy holding account
bean-balance books.bean "Assets:Etsy:Payout" "2025-07-21"

# Generate an income statement for the last period
bean-report books.bean income_statement -e 2025-07-21

7. Attach Source Docs​

Create a completely self-contained and auditable record by linking to source documents directly in your transaction metadata. This is perfect for supplier receipts, shipping label PDFs, or purchase orders.

2025-07-12 * "Etsy shipping label for order #4321"
  Expenses:ShippingLabel         4.25 USD
  Assets:Bank:Operating
  document: "docs/labels/2025-07-12-order4321.pdf"

Know Your Etsy Fees (U.S.)​

To get a true picture of your profit, track each fee type in its own expense account:

• Listing fee: $0.20 per item, which automatically renews every 4 months or after a sale. (Etsy)
• Transaction fee: 6.5% of the total order amount (including item price, shipping, and gift-wrapping). (Etsy)
• Payment processing fee: Varies by country, but for the U.S. it's typically 3% + $0.25 per order processed through Etsy Payments. (Etsy Help)
• Subscription (Etsy Plus): An optional $10/month for additional tools.

Sales-Tax & Compliance Tips​

• While Etsy remits sales tax for most U.S. states, be aware that selling on other platforms or having a physical workshop can create additional tax obligations ("nexus"). Track your sales thresholds carefully.
• Once the 1099-K thresholds apply to your shop, ensure your Income:Etsy:Sales total in Beancount reconciles to the gross amount on the form to the cent. (IRS)

Common Pitfalls (and Fixes)​

• Pitfall: Net-deposit accounting.
  • Fix: Always use the payment CSV to break deposits into gross sales, fees, and reserves.
• Pitfall: Stale inventory costs.
  • Fix: Record your supply and material purchases as inventory the moment you buy them. Don’t wait until the finished product sells.
• Pitfall: Refund blind spots.
  • Fix: When issuing a refund, log the expense and also reverse the original COGS entry to move the cost back into your inventory account.
• Pitfall: Ignoring reserve holds.
  • Fix: Open an Assets:Etsy:Reserve account to track money that Etsy is holding. This keeps your cash-flow statements honest.

Quick-Start Checklist​

• In your Shop Manager, set up monthly statements and download your first CSV.
• Clone the Beancount starter repository and sketch out your shop's chart of accounts.
• Decide on cash or accrual accounting and commit to it.
• Write a basic importer script or rules file and schedule a weekly sync.
• Reconcile your payouts, inventory levels, and bank balance every Monday.
• Generate an income statement each month and review your gross margin trends.
• Back up your .bean files using Git and an off-site storage solution.

Ready to stitch bookkeeping into your creative workflow? Install Beancount, commit your first entry, and let plain-text clarity free up more time at the workbench. Happy bean-keeping!

In the labyrinth of personal finance management, Beancount emerges as a beacon of clarity and precision for plain-text bookkeeping. Particularly when it comes to managing receivables—money expected from others—Beancount offers a structured approach to keep your financial records in impeccable order. This blog will guide you through the intricacies of tracking receivables, processing refunds, and managing unresolved transactions with Beancount. Whether you're returning a purchase, lending money, or awaiting a refund, this post is your roadmap to financial clarity.

Understanding Receivables in Beancount:​

Receivables represent money that is owed to you. This could be from a variety of scenarios, such as after a shopping return awaiting a refund or when you lend money to someone. For instance, consider you've returned a watch strap to an online store like Amazon.com and are awaiting a refund. In Beancount, this transaction is recorded as money moving from your credit card liability to your assets as receivables:

2023-10-31 * "Amazon.com" "[Return] Watch Strap"
    Liabilities:CreditCard:Chase                                 -12.00 USD
    Assets:Receivables

Managing Refunds:​

Once the refund is processed and you receive the money, another transaction is recorded to offset the balance in Receivables. This ensures that your accounts reflect the money back in your possession:

2023-11-01 * "Amazon.com" "[Refund] Watch Strap"
    Liabilities:CreditCard:Chase                                  12.00 USD
    Assets:Receivables

Complete Transaction Cycle:​

A complete in-and-out transaction involving receivables is combining both transactions above and showcased as follows, demonstrating a balanced account post-refund:

2023-10-31 * "Amazon.com" "[Return] Watch Strap"
    Liabilities:CreditCard:Chase                                 -12.00 USD
    Assets:Receivables

2023-11-01 * "Amazon.com" "[Refund] Watch Strap"
    Liabilities:CreditCard:Chase                                  12.00 USD
    Assets:Receivables

Handling Unresolved Transactions:​

For transactions where the refund or repayment has not yet been received, Beancount employs the #UNRESOLVED tag. This tag helps in identifying and tracking amounts that are still pending. For example:

2023-10-31 * "John Doe" "Lending Money" #UNRESOLVED
    Liabilities:CreditCard:Chase                                 -100.00 USD
    Assets:Receivables

By focusing on transactions tagged as #UNRESOLVED, you can quickly ascertain which amounts are yet to be settled.

Maintaining a Zero Balance:​

In a proper ledger, the sum of all transactions under the Assets:Receivables account, excluding those tagged with #UNRESOLVED, should ideally return to zero. This ensures that all expected funds have been accounted for, maintaining the integrity of your financial records.

For example, a valid ledger might look like this, with an unresolved transaction clearly marked, awaiting closure:

2023-10-31 * "Amazon.com" "[Return] Watch Strap"
    Liabilities:CreditCard:Chase                                 -12.00 USD
    Assets:Receivables

2023-11-01 * "Amazon.com" "[Refund] Watch Strap"
    Liabilities:CreditCard:Chase                                  12.00 USD
    Assets:Receivables

2023-10-31 * "John Doe" "Lending Money" #UNRESOLVED
    Liabilities:CreditCard:Chase                                 -100.00 USD
    Assets:Receivables

An invalid ledger is one where a transaction causes the Receivables account not to zero out, necessitating the #UNRESOLVED tag for correction.

Conclusion​

Navigating receivables in Beancount doesn't have to be daunting. With a clear understanding of how to record transactions, manage refunds, and keep an eye on unresolved transactions, you can maintain accurate and reliable financial records. Embracing the structured approach of Beancount for receivables management not only simplifies your financial tracking but also brings peace of mind, knowing that every dime is accounted for. So, why not leverage the power of Beancount to make your financial management as smooth

As a founder, you wear every hat—CEO, salesperson, product manager, and, yes, bookkeeper. But as your business grows, the hours spent reconciling transactions start to feel less like savvy bootstrapping and more like a costly distraction. So, when is the right time to hand off the books?

The answer isn't about giving up control; it's about making a data-driven decision. Here’s how to use your Beancount ledger to decide whether to continue DIY-ing or hire a professional.

TL;DR: If you bill your time at $85/hour and spend just four hours a month on bookkeeping, that work is costing you$340 in lost revenue. A typical remote bookkeeper starts around $249/month—plus they free you up to actually grow the business.

1. Put a Price on Your Own Time​

The most important metric in this decision is your own opportunity cost. Every hour you spend categorizing expenses is an hour you’re not spending on sales, product development, or strategy.

The math is simple:

1. Track how many hours you spend on bookkeeping tasks each month (reconciling, coding, fixing errors).
2. Multiply those hours by your effective billable rate.
3. Compare that figure to the monthly fee of an external bookkeeper (a typical starting rate is around $249/month).

If the cost of your time is higher, you have an obvious delegation win. You can even track this directly in Beancount.

; Track the opportunity cost of your time
2025-07-31 * "July bookkeeping time"
  Expenses:Admin:BookkeepingTime      4.00 H   ; Your custom unit for hours
  Equity:OwnerTime                   -340.00 USD
  ; metadata: rate:85

Here, H is a custom currency for "Hours." You can book the time directly and use a script or a price directive to assign its dollar value, making the cost of your own labor an explicit part of your financial reports.

2. Count the Hidden Costs of DIY​

The cost of your time isn't the only factor. DIY bookkeeping carries risks that can be far more expensive than a monthly retainer.

• Tax Slip-ups: Messy books are a nightmare for tax preparers. A CPA may charge anywhere from $150–$400 per hour just to clean up your records before they can even start on the tax return.
• Missed Deductions & IRS Fines: Small, unintentional errors—like misclassifying an expense or forgetting to record a cash transaction—can compound over time, leading to penalties, interest, and a higher tax bill.
• Founder Burnout: The mental drag of late-night reconciling is real. It drains focus and energy that should be dedicated to high-leverage activities like sales and product innovation.

Beancount Mitigation: You can reduce errors by adding a Git pre-commit hook that refuses to commit changes if bean-check fails or if transactions lack a category tag. This enforces discipline, even when you're tired.

3. Three Ways a Bookkeeper (or Beancount Discipline) Saves Money​

Whether you hire a pro or simply level up your own process, good bookkeeping pays for itself.

1. Cleaner Tax Filing: Organized, accurate books mean fewer CPA hours spent on cleanup, which directly translates to a lower bill.
2. Real-time Cash Insight: Knowing your exact cash position helps you avoid costly overdraft fees and the need for last-minute, high-interest financing.
3. Stress Buffer: Stable, predictable financial operations reduce founder stress, leading to better decision-making and a healthier business culture.

4. When You Shouldn’t Hire Yet​

Hiring a bookkeeper isn't always the right move. In some cases, DIY is still the smarter financial choice.

• You're pre-revenue or have razor-thin cash flow. At this stage, every dollar should go toward sales and customer acquisition. Focus on getting revenue in the door first.
• Your finances are simple. If you have one bank account, one Stripe feed, and fewer than ~60 transactions a month, you can likely manage everything in Beancount and Fava in less than an hour a week.

5. The Hybrid Option: Your “Bookkeeper-Ready” Beancount Ledger​

The best solution is often a hybrid one. Use Beancount to do the heavy lifting yourself, but keep your books so clean that a professional can jump in for high-value tasks.

• Automate Ingestion: Set up bean-extract to run nightly, pulling in new transactions automatically.
• Standardize Your Chart of Accounts: Use conventional account names (Expenses:Software, Assets:Bank:Checking) so any pro can understand your ledger instantly.
• Attach Source Documents: For every expense over $75, use link: metadata to attach a PDF of the receipt or invoice.
• Follow a Monthly Close Checklist:
  1. Reconcile all bank and credit card accounts.
  2. Run bean-check to ensure there are no errors.
  3. Export PDF statements with bean-report balance_sheet and bean-report income_statement.
• Perform a Quarterly Hand-off: Give your bookkeeper or CPA a Git tag or a simple archive (books-Q3-2025.tar.gz). They can verify your work, add complex adjusting entries (like accruals and depreciation), and prepare tax packets.

This model keeps your costs low because the professional is only touching clean, reviewed data, while you still get the benefit of pro-level financial statements.

6. Quick Decision Matrix​

7. Next Steps​

1. Log your time. For your next bookkeeping session, track every minute you spend on it.
2. Run the numbers. Multiply that time by your billable rate and compare it to the market rates above.
3. Choose your path. Either tighten up your Beancount workflow using the hybrid model or start interviewing bookkeepers who are comfortable working from a plain-text ledger.

Either way, intentional bookkeeping is always cheaper than winging it. With Beancount as your immutable source of truth, you’ll know exactly when professional help pays for itself—and when it doesn’t.

A thriving company and a healthy wallet share one trait: boundaries.

For any business owner, from a solo freelancer to a growing startup founder, one of the most critical financial disciplines is the strict separation of business and personal finances. Mingling funds—using your business account for groceries or paying a business vendor from your personal checking—creates a messy, opaque financial picture. This not only invites scrutiny from tax authorities but also robs you of clear insights into your company's actual performance.

Fortunately, a plain-text accounting system like Beancount provides the perfect framework for enforcing these essential boundaries right in your ledger.

Why Separation Matters​

Failing to separate your finances isn't just a bad habit; it carries significant risks and masks valuable business intelligence.

• IRS Clarity: The IRS isn't just suggesting you keep separate bank accounts; they strongly urge it. When business and personal funds are commingled, it becomes difficult to prove which expenses are legitimate business deductions. This ambiguity can lead to questions and complications you're better off avoiding.
• Audit Risk: Mixing transactions is a major red flag for auditors. If your books are a tangled mess of personal and business activity, you risk having valid deductions disallowed or even facing penalties. A clean, separate ledger demonstrates professionalism and makes any potential audit smoother and less stressful.
• Cleaner Insights: How can you know your true profit margin if your business's cash flow is clouded by personal spending? A stand-alone business ledger gives you an unfiltered view of your company's financial health. You can accurately track revenue, analyze expenses, and calculate tax liabilities without the "noise" of your personal financial life.

Key Differences at a Glance​

The purpose, rules, and structure of business and personal bookkeeping are fundamentally different. Understanding these contrasts is key to maintaining accurate records.

A Four‑Step Beancount Blueprint​

Beancount makes it simple to erect a firm wall between your two financial worlds. Here’s a practical workflow to get it right.

• 1 — Open Dedicated Accounts​

Before you even write your first Beancount entry, open a dedicated business checking account and business credit card. This physical separation is the foundation of clean bookkeeping. Once that's done, mirror this structure in your Beancount ledger.

2025-07-23 open Assets:Bank:Business   USD
2025-07-23 open Assets:Bank:Personal   USD

This simple setup ensures that every transaction can be clearly assigned to either your business or personal finances from the moment it occurs.

• 2 — Record Owner Contributions & Draws​

As an owner, you will move money between your personal funds and the business. These are not income or expenses. Instead, they are tracked through an Equity account.

• Contribution: When you put your own money into the business to get it started or cover a shortfall.
• Draw: When you take money out of the business for personal use (this is how many sole proprietors "pay" themselves).

; Capital injection to start the business
2025-07-23 * "Owner contribution"
  Assets:Bank:Business    10,000.00 USD
  Equity:Owner:Contrib

; Taking money out for personal living expenses
2025-08-05 * "Owner draw for rent"
  Equity:Owner:Draw        2,500.00 USD
  Assets:Bank:Business

By recording these as equity transactions, you ensure they don't incorrectly inflate your business expenses or reduce your reported profit.

• 3 — Handle Mixed Receipts Quickly​

Mistakes happen. You might accidentally use your business card to pay for a personal dinner. The key is to correct it immediately in your ledger. Don't delete the transaction; reclassify it as an owner's draw.

2025-08-07 * "Personal groceries on biz card"
  Equity:Owner:Draw           72.35 USD
  Assets:Bank:Business

This entry correctly reflects that business funds were used for a personal expense, treating it as money you've taken out of the company. This prevents you from accidentally claiming a non-deductible personal expense on your taxes.

• 4 — Reconcile & Review on a Schedule​

Consistency is your best defense against messy books. Set aside time weekly or monthly to reconcile your business accounts. Use Beancount's tools to ensure your ledger matches your bank statements and to review your company's performance.

# Check your business bank balance against your statement
bean-balance books.bean "Assets:Bank:Business"

# Generate an income statement to review profitability
bean-report  books.bean income_statement -e 2025-08-31

This regular review habit satisfies IRS record-keeping requirements and keeps you informed about the financial health of your business.

Tax Considerations​

• Estimated Taxes: To avoid a painful tax bill, treat your future taxes as an ongoing business expense. Create liability accounts (Liabilities:Tax:Federal, Liabilities:Tax:State) and regularly move a set percentage of every deposit into them. When quarterly payments are due, the cash is already waiting.
• Non‑deductible Personal Costs: Remember the IRS rule: business expenses must be both "ordinary and necessary" for your work. Your personal meals, commuting costs, and non-business subscriptions do not qualify and must be kept entirely out of your business's profit and loss statement.

Quick‑Start Checklist​

• Open business-only bank and credit accounts.
• Build a Beancount chart of accounts with Assets:Bank:Business, Equity:Owner:Contrib, and Equity:Owner:Draw.
• Decide on your accounting basis (cash or accrual) and note it in your Beancount options.
• Tag any accidental personal charges on business cards as Equity:Owner:Draw immediately.
• Reconcile weekly; back up your .bean file to a private Git remote.
• Review your income statement, balance sheet, and cash-flow reports every month.

Bottom line: Separate money, separate ledgers. Beancount makes the wall between your business and personal finances explicit—and version-controlled—so your business stays audit-ready while your latte habit remains nobody’s business but yours. Happy bean-keeping!

Real estate transactions may constitute the largest financial activity in a family's lifetime. This article explains how to model real estate in Beancount. I treat real estate as an asset and the appreciation of the house as unrealized gain. Additionally, the mortgage is modeled as a liability, and the interest is considered an expense.

Let's assume that Mr. A purchased a luxury home located at 123 ABC Street, XYZ City, CA, 12345 on January 1, 2020, for a price of 1 million. The interest rate is 3.0%, the down payment is 20%, and the loan amount is 800,000.

Create Accounts​

Firstly, we treat the house as an Asset. Since the house is being listed as an Asset, it needs to be given a unit. In this case, the unit quantity is only one, it's unlikely there will be multiple, and even if it's the nth house, we would want to record it in a separate Asset. That is to say, one house corresponds to one Asset, and this Asset has a special unit, its value can only possibly be 1.

2019-12-31 commodity HOUSE.ABC
  name: "123 ABC Street, XYZ City, CA, 12345"

2019-12-31 open Assets:Property:US:CA:123ABC                        HOUSE.ABC
2019-12-31 open Liabilities:Bank:US:SomeBank:Mortgage:Loan          USD

In the first line here, we defined a commodity unit representing the house. In the fourth line, we defined an Asset account, which holds the commodity unit previously defined as the house. In the fifth line, we defined an account for the lending bank. As it's a liability, it falls under the Liabilities category.

Purchase​

With the accounts set up as above, the act of buying a house is equivalent to

borrowing money (debt) + spending money (down payment) = 1 house in asset

The most important reference when buying a property is likely the Buyer’s Settlement Statement, which clearly outlines the flow of money.

2020-01-01 * "Buying the house"
    Assets:Property:US:CA:123ABC                  1 HOUSE.ABC {1,000,000 USD}
    Assets:Bank:US:SomeBankA                      -100,000 USD
    Assets:Bank:US:SomeBankB                      -101,000 USD
    Liabilities:Bank:US:SomeBank:Mortgage:Loan    -800,000.00 USD
    Expenses:Home:Insurance                       1,000 USD
    Expenses:Home:Mortgage:Loan:ClosingCost

Here, we're detailing the transaction of buying the house, where money flows out from some banks (used for down payment and other expenses), a loan is taken (adding to liabilities), and a house is gained (added to assets).

Pay back mortgages​

Based on the above purchase record, we currently owe 800,000 USD. Due to the interest, and considering that all loans in the US are amortized equally in terms of principal and interest, the monthly payment includes a portion for interest and a portion for principal. In the early stages, the interest constitutes the majority.

To record the loan repayment, all you need to do is check your loan bank's statement. You just need to know how much of the principal you are repaying each month, and the rest is interest. The interest is counted as an Expense.

2020-02-01 * "Mortgage payment"
    Assets:Bank:US:SomeBank:Saving:Joint              -3,372.83 USD
    Liabilities:Bank:US:SomeBank:Mortgage:Loan         1,376.26 USD
    Expenses:Home:Mortgage:Loan:Interest

This entry details the monthly mortgage payment which is subtracted from your joint savings account. The repayment of principal reduces the liability, while the interest part is treated as an expense.

Appreciation​

If you want to record the appreciation of the property, some people create a separate account[, only recording the appreciation of the current property. Considering that the value of the house may increase or decrease, this appreciation may be negative. The advantage of this is that in the summary of your total assets, these two accounts will be included, one for the value of the house at the time of the transaction, and the other for the current appreciation of the house, thus reflecting the real-time price of the house.

I did not adopt this method, mainly for the following reasons:

1. The current value of the house can only be an estimate, for reference only, without practical value. Usually, I can only get the evaluation of the property on websites like Redfin or Zillow, and I personally don't think it has high reference value. I also did not consider incorporating these appreciations into total assets in real time.
2. Personally, I think before the mortgage is paid off, if the cash flow of the house is negative, to some extent, the property is still a liability. Therefore, incorporating it into assets prematurely will give you an illusion of enriched assets and appreciation, and I personally want to avoid this illusion.

The method I use to record property appreciation, which will also be discussed later on how to model RSUs. This method is to use a virtual currency unit. Assuming your base currency is USD, we can use USD.UNVEST (it seems that there is no need to create a new Commodity for this) to indicate that this asset is calculated in a special currency. The growth or reduction of this asset will not be recorded in USD. This way, I can achieve my original goal, that is, to record the appreciation of the house, and this appreciation will not be included in the final balance sheet (Balance Sheet).

2020-01-01 price HOUSE.ABC                          1,000,000 USD
2025-01-01 price HOUSE.ABC                          1,400,000 USD.UNVEST

You only need to price your property to USD.UNVEST regularly.

So, on Fava's Commodity page, you can track the trend of the reference price of the house. But on the Balance Sheet page, the price of the house is still the price of the house at the time of the transaction. That is to say, your total assets are still your down payment money at that time, plus the principal you keep paying off. The final change of this asset should only occur when you buy a house.

Sell​

Because no property has been sold yet and the various miscellaneous fees in the middle are unclear, this is a hypothetical scenario.

Suppose, on January 1, 2025, the property has appreciated to $1,400,000, and some reference data are as follows:

Person A decides to sell the property, and the final selling price of the house is $1,300,000.

2025-01-01 * "Selling the house"
    Assets:Property:US:CA:123ABC                  -1 HOUSE.ABC {1,300,000 USD}
    Liabilities:Bank:US:SomeBank:Mortgage:Loan    709,656.20 USD
    Expenses:Home:Agent:Fee                       72,000 USD
    Expenses:Home:ClosingCost                     10,000 USD
    Expenses:Home:Tax                             90,000 USD
    Assets:Bank:US:SomeBankA

Here it is assumed that 2 out of 5 years are self-occupied, so the appreciation of 500,000 does not need to be taxed. I randomly calculated a number here. In the end, the money that enters Person A's account is $418,343.8, of which 200,000 is the down payment at that time, and about 100,000 in interest has been paid. So, in the end, the book profit for Person A is around 100,000. It is worth noting that my calculation is not fair, after all, Person A has saved rent for these 5 years, and there may be other expenses on the house, such as maintenance, decoration, and so on.

To reflect this in the balance sheet, you can add this pricing.

2025-01-01 price HOUSE.ABC                          1,300,000 USD

Hello everyone! In today's blog post, we're diving into the world of Beancount, a double-entry accounting tool that's loved by many for its simplicity and power. More specifically, we're going to talk about two key concepts: Receivables and Payables.

Understanding these terms is crucial to using Beancount (or any double-entry accounting system) effectively. But don't worry if you're a beginner - we're going to break it all down, step by step!

Receivables and Payables: The Basics​

In accounting, "receivables" and "payables" are terms used to track money that is owed. "Receivables" refers to money that others owe to you, while "payables" refers to money that you owe to others.

Let's take an example:

1. Accounts Receivable (A/R): Suppose you own a bookstore and a customer buys a book on credit. The money they owe you for the book is an account receivable.

2. Accounts Payable (A/P): On the flip side, imagine you order a new set of books from a publisher, but you don't pay for them upfront. The money you owe the publisher is an account payable.

In Beancount, these are typically tracked through corresponding accounts. The main benefit here is that it provides you with a clear and accurate picture of your financial position at any point in time.

Setting Up Receivables and Payables in Beancount​

The structure of your Beancount file can be as simple or as complex as you need it to be. For receivables and payables, you'll likely want to create separate accounts under your Assets and Liabilities sections.

Here is a simple example:

1970-01-01 open Assets:AccountsReceivable
1970-01-01 open Liabilities:AccountsPayable

Tracking Transactions​

Payee side​

After setting up your accounts, you can track transactions that involve receivables and payables. Let's look at an example:

2023-05-29 * "Sold books to customer on credit"
  Assets:AccountsReceivable  100 USD
  Income:BookSales          -100 USD

Here, you're adding $100 to your receivables because a customer owes you this amount. Simultaneously, you're reducing your income by the same amount to maintain the balance (since you haven't actually received the money yet).

When the customer eventually pays, you'll record it like this:

2023-06-01 * "Received payment from customer"
  Assets:Bank:Savings        100 USD
  Assets:AccountsReceivable -100 USD

Payer side​

The same principle applies for payables, but with reversed signs:

2023-05-30 * "Bought books from publisher on credit"
  Liabilities:AccountsPayable  200 USD
  Expenses:BookPurchases     -200 USD

And when you pay off your debt:

2023-06-02 * "Paid off debt to publisher"
  Liabilities:AccountsPayable -200 USD
  Assets:Bank:Checking        200 USD

Wrapping Up​

Receivables and payables are at the heart of any accounting system. By accurately tracking these, you gain a comprehensive understanding of your financial health.

This is just a starting point, and Beancount is capable of much more. I hope this blog post helps clarify these important concepts. As always, happy accounting!

In today's blog post, we will be breaking down a Beancount ledger for businesses, which will help you understand the intricacies of this plain text double-entry accounting system.

Let's start with the code first:

1970-01-01 open Assets:Bank:Mercury
1970-01-01 open Assets:Crypto

1970-01-01 open Equity:Bank:Chase

1970-01-01 open Income:Stripe
1970-01-01 open Income:Crypto:ETH

1970-01-01 open Expenses:COGS
1970-01-01 open Expenses:COGS:Contabo
1970-01-01 open Expenses:COGS:AmazonWebServices

1970-01-01 open Expenses:BusinessExpenses
1970-01-01 open Expenses:BusinessExpenses:ChatGPT

2023-05-14 * "CONTABO.COM" "Mercury Checking ••1234"
  Expenses:COGS:Contabo                               17.49 USD
  Assets:Bank:Mercury                                -17.49 USD

2023-05-11 * "Amazon Web Services" "Mercury Checking ••1234"
  Expenses:COGS:AmazonWebServices                  14490.33 USD
  Assets:Bank:Mercury                             -14490.33 USD

2023-03-01 * "STRIPE" "Mercury Checking ••1234"
  Income:Stripe                                   -21230.75 USD
  Assets:Bank:Mercury                              21230.75 USD

2023-05-18 * "customer_182734" "0x5190E84918FD67706A9DFDb337d5744dF4EE5f3f"
  Assets:Crypto                                         -19 ETH {1,856.20 USD}
  Income:Crypto:ETH                                      19 ETH @@ 35267.8 USD

Understanding the Code​

1. Opening Accounts: The code starts by opening a series of accounts on 1970-01-01. These include a mix of asset accounts (Assets:Bank:Mercury and Assets:Crypto), an equity account (Equity:Bank:Chase), income accounts (Income:Stripe and Income:Crypto:ETH), and expense accounts (Expenses:COGS, Expenses:COGS:AmazonWebServices, Expenses:BusinessExpenses, and Expenses:BusinessExpenses:ChatGPT).

2. Transactions: It then progresses to record a series of transactions between 2023-03-01 and 2023-05-18.

   • The transaction on 2023-05-14 represents a payment of $17.49 to CONTABO.COM from Mercury Checking ••1234. This is recorded as an expense (Expenses:COGS:Contabo) and a corresponding deduction from the Assets:Bank:Mercury account.

   • Similarly, the transaction on 2023-05-11 represents a payment of $14490.33 to Amazon Web Services from the same bank account. This is logged under Expenses:COGS:AmazonWebServices.

   • The transaction on 2023-03-01 shows income from STRIPE being deposited into Mercury Checking ••1234, totaling $21230.75. This is recorded as income (Income:Stripe) and an addition to the bank account (Assets:Bank:Mercury).

   • The last transaction on 2023-05-18 represents a crypto transaction involving 19 ETH from a customer. This is tracked under Assets:Crypto and Income:Crypto:ETH. The {1,856.20 USD} shows the price of ETH at the time of transaction, while the @@ 35267.8 USD specifies the total value of the 19 ETH transaction.

In all transactions, the principle of double-entry accounting is maintained, ensuring that the equation Assets = Liabilities + Equity always holds true.

Final Thoughts​

This Beancount ledger provides a straightforward yet robust system for tracking financial transactions. As seen in the final transaction, Beancount is flexible enough to account for non-traditional assets like cryptocurrency, which is a testament to its utility in our increasingly digital financial landscape.

We hope this breakdown helps you better understand the structure and capabilities of Beancount, whether you're a seasoned accountant or a beginner trying to keep track of your personal finances. Stay tuned for our next blog post, where we'll delve further into advanced Beancount operations.

We are thrilled to announce that as of May 1st, 2023, we will be reintroducing the free plan for new customers. This decision comes after making significant improvements to our platform and optimizing our resources in order to better serve all of our customers, both free and paid.

The free plan has always been an essential part of our vision to provide an accessible and user-friendly service for everyone. We believe that the changes we've made over the past months will allow us to deliver an even better experience for our users while maintaining the quality of service for our Pro plan customers.

New customers who register after May 1st, 2023, will have access to the Free plan.

Your support and loyalty have been instrumental in making this reintroduction of the free plan financially possible. It is through your contributions that we have been able to invest in our infrastructure and support systems, ensuring that we can continue to deliver the high-quality service you expect while also expanding access to our platform for new users. Your commitment to our vision has helped us grow and evolve, and we are truly grateful for your ongoing partnership. Together, we are building a thriving community and empowering users from all walks of life to achieve their goals.

If you have any questions or concerns, please don't hesitate to reach out to us. We are always here to listen to your feedback and address any issues you may have. Thank you for your continued support, and we look forward to providing you with the best service possible.

Example Account Name​

Assets:US:BofA:Checking

Account Types​

Assets          +
Liabilities     -
Income          -
Expenses        +
Equity          -

Commodities​

CNY, EUR, CAD, AUD
GOOG, AAPL, RBF1005
HOME_MAYST, AIRMILES
HOURS

Directives​

General syntax

YYYY-MM-DD <Directive> <Parameters...>

Opening & Closing Accounts​

2001-05-29 open Expenses:Restaurant
2001-05-29 open Assets:Checking     USD,EUR  ; Currency constraints

2015-04-23 close Assets:Checking

Declaring Commodities (Optional)​

1998-07-22 commodity AAPL
  name: "Apple Computer Inc."

Prices​

2015-04-30 price AAPL   125.15 CNY
2015-05-30 price AAPL   130.28 CNY

Notes​

2013-03-20 note Assets:Checking "Called to ask about rebate"

Documents​

2013-03-20 document Assets:Checking "path/to/statement.pdf"

Transactions​

2015-05-30 * "Some narration about this transaction"
  Liabilities:CreditCard   -101.23 CNY
  Expenses:Restaurant       101.23 CNY

2015-05-30 ! "Cable Co" "Phone Bill" #tag ˆlink
  id: "TW378743437"               ; Meta-data
  Expenses:Home:Phone  87.45 CNY
  Assets:Checking                 ; You may leave one amount out

Postings​

  ...    123.45 USD                             Simple
  ...        10 GOOG {502.12 USD}               With per-unit cost
  ...        10 GOOG {{5021.20 USD}}            With total cost
  ...        10 GOOG {502.12 # 9.95 USD}        With both costs
  ...   1000.00 USD   @ 1.10 CAD                With per-unit price
  ...        10 GOOG {502.12 USD} @ 1.10 CAD    With cost & price
  ...        10 GOOG {502.12 USD, 2014-05-12}   With date
  ! ...   123.45 USD ...                        With flag

Balance Assertions and Padding​

; Asserts the amount for only the given currency:
2015-06-01 balance Liabilities:CreditCard  -634.30 CNY

; Automatic insertion of transaction to fulfill the following assertion:
2015-06-01pad Assets:Checking Equity:Opening-Balances

Events​

2015-06-01 event "location" "New York, USA"
2015-06-30 event "address" "123 May Street"

Options​

option "title" "My Personal Ledger"

Other​

pushtag #trip-to-peru
...
poptag  #trip-to-peru
; Comments begin with a semi-colon

Discover the Magic of Plain Text Accounting with Beancount

Introduction​

Welcome to a world where accounting is no longer a daunting task. Today, we introduce you to Beancount, a powerful, flexible, and intuitive plain text accounting tool. Beancount empowers you to take control of your finances by providing a transparent and straightforward approach to managing your money.

In this comprehensive guide, we will delve into the basics of Beancount, explain its core concepts, and walk you through its simple yet powerful features. By the end of this blog, you'll have a solid understanding of Beancount and be ready to start using it to organize and analyze your financial life.

What is Beancount?​

Beancount is an open-source, plain text accounting system created by Martin Blais. Inspired by John Wiegley's Ledger system, Beancount aims to provide a robust and reliable method to manage personal and small business finances using plain text files. With Beancount, you can track your income, expenses, investments, and much more with ease.

Why Beancount?​

Plain text accounting offers several advantages over traditional spreadsheet-based or software-based accounting systems:

• Transparency: Beancount files are human-readable, making it easy to understand and audit your financial data.
• Flexibility: Beancount can be easily customized to fit your specific needs, and you can use your favorite text editor and version control system to manage your financial data.
• Portability: Your financial data can be accessed on any device, and it's easy to transfer between systems or share with others.
• Future-proof: Plain text files are universally compatible, ensuring that your financial data will remain accessible, even as technology evolves.

Beancount's Core Concepts​

To use Beancount effectively, it's crucial to understand its core concepts:

• Transactions: Financial events, such as income, expenses, or transfers between accounts, are recorded as transactions.
• Accounts: Transactions involve one or more accounts, such as assets, liabilities, income, or expenses.
• Double-entry bookkeeping: Beancount enforces double-entry bookkeeping, ensuring that every transaction has balanced debits and credits.
• Directives: Beancount uses a set of directives to define transactions, account openings, and other financial events.

Getting Started with Beancount​

To start using Beancount, follow these simple steps:

• Install Beancount: Install Beancount on your system using the provided installation instructions for your operating system.
• Create your Beancount file: Create a new plain text file with the .beancount extension (e.g., my_finances.beancount).
• Define your accounts: Use the "open" directive to define the accounts you'll use in your transactions.
• Record transactions: Use the "txn" directive to record your financial transactions.

Or simply sign up at https://beancount.io. Here are some plain text accounting examples -

Example 1: Basic Transaction

2023-04-01 open Assets:Checking
2023-04-01 open Expenses:Groceries

2023-04-10 txn "Grocery Store" "Buying groceries"
  Assets:Checking         -50.00 USD
  Expenses:Groceries       50.00 USD

In this example, we open two accounts, Assets:Checking and Expenses:Groceries. On April 10, 2023, we record a transaction for buying groceries worth $50. The transaction reduces the balance of Assets:Checking by$50 (debit) and increases the balance of Expenses:Groceries by $50 (credit).

Example 2: Income and Expense Transaction

2023-04-01 open Assets:Checking
2023-04-01 open Income:Salary
2023-04-01 open Expenses:Rent

2023-04-05 txn "Employer" "Salary payment"
  Assets:Checking       2000.00 USD
  Income:Salary        -2000.00 USD

2023-04-06 txn "Landlord" "Monthly rent payment"
  Assets:Checking       -1000.00 USD
  Expenses:Rent          1000.00 USD

In this example, we open three accounts: Assets:Checking, Income:Salary, and Expenses:Rent. On April 5, 2023, we record a salary payment transaction of $2000. The transaction increases the balance of Assets:Checking by$2000 (credit) and decreases the balance of Income:Salary by $2000 (debit). On April 6, 2023, we record a rent payment transaction of$1000. The transaction reduces the balance of Assets:Checking by $1000 (debit) and increases the balance of Expenses:Rent by$1000 (credit).

Example 3: Transfer Between Accounts

2023-04-01 open Assets:Checking
2023-04-01 open Assets:Savings

2023-04-15 txn "Bank" "Transfer from Checking to Savings"
  Assets:Checking       -500.00 USD
  Assets:Savings         500.00 USD

In this example, we open two accounts: Assets:Checking and Assets:Savings. On April 15, 2023, we record a transaction to transfer $500 from the checking account to the savings account. The transaction reduces the balance of Assets:Checking by$500 (debit) and increases the balance of Assets:Savings by $500 (credit).

These examples illustrate the basic concepts of Beancount's double-entry bookkeeping system. By properly recording transactions, users can maintain accurate records of their financial activities and generate reports to gain insights into their financial situation.

Generating Reports and Analyzing Data​

Beancount comes with a set of powerful tools for generating financial reports, including balance sheets, income statements, and more. You can also use Fava, a web-based user interface for Beancount, to visualize and interact with your financial data. https://beancount.io is built upon Fava with MIT license.

Conclusion​

Embrace the power and simplicity of plain text accounting with Beancount. By understanding its core concepts and following the steps outlined in this guide, you'll be well on your way to managing your personal or small business finances with ease and precision. As you grow more comfortable with Beancount, you can explore advanced features and customizations to tailor the system to your unique needs.

Whether you're looking to track your spending, plan for the future, or gain insights into your financial habits, Beancount offers the flexibility and transparency needed to achieve your goals. With its user-friendly approach, Beancount has the potential to revolutionize the way you manage your finances and empower you to take control of your financial future.

Now that you have a solid foundation in Beancount, it's time to embark on your plain text accounting journey. Say goodbye to cumbersome spreadsheets and convoluted software, and welcome the world of Beancount. Happy accounting!