9 posts tagged with "Tracking"

Running a successful real estate business requires more than just closing deals and finding perfect properties for your clients. Behind every successful realtor is a solid financial management system that keeps income organized, expenses tracked, and taxes under control. If you're a real estate professional struggling to keep your books in order, you're not alone—and this guide is here to help.

The Unique Financial Challenges Realtors Face​

Real estate professionals deal with financial complexities that many other small business owners don't encounter. Understanding these challenges is the first step toward managing them effectively.

Income Fluctuations and Cash Flow​

Unlike salaried employees, realtors experience dramatic income swings throughout the year. You might close three deals in one month and then go weeks without a commission check. This irregularity makes budgeting and cash flow management particularly challenging. You need to plan for lean months while maximizing the benefits of high-earning periods.

The seasonal nature of real estate compounds this issue. Spring and summer typically bring more activity, while winter months can be significantly slower in many markets. This means you must be strategic about saving during peak seasons to cover both business expenses and personal needs during quieter times.

Commission-Based Income Tracking​

When you work on commission, every transaction involves multiple parties and potential splits. You might be splitting commissions with your brokerage, other agents, or team members. Keeping accurate records of who gets paid what—and when—is essential for both tax purposes and business planning.

Additionally, commission structures can vary from deal to deal. Some transactions might involve referral fees, others might have different split arrangements, and you need to track all of these accurately to understand your true earnings.

Business Expense Management​

Real estate professionals incur numerous tax-deductible expenses, but tracking them all requires diligence. Common deductible expenses include:

Marketing and Advertising: Professional photography, virtual tours, listing ads, social media campaigns, direct mail, and your website all add up quickly. These costs are fully deductible as legitimate business expenses.

Mileage and Transportation: You're constantly driving to showings, open houses, inspections, and client meetings. The IRS allows you to deduct business mileage at a standard rate (currently 67 cents per mile for 2025), which can result in substantial tax savings if you track your trips accurately.

Continuing Education: Real estate licenses require ongoing education. Course fees, exam costs, and related materials are all deductible business expenses.

Professional Fees and Memberships: MLS fees, realtor association dues, broker fees, and professional liability insurance all qualify as deductible expenses.

Home Office Deduction: If you maintain a dedicated space in your home exclusively for business use, you may qualify for the home office deduction, which covers a portion of your rent or mortgage, utilities, and maintenance costs.

Staging and Property Preparation: Costs associated with staging properties for sale can often be deducted as business expenses, though this depends on your specific arrangement with clients.

Tax Complexity and Compliance​

As a self-employed real estate professional, you're responsible for paying quarterly estimated taxes. Missing these payments can result in penalties and interest charges. You'll also need to manage your self-employment tax, which covers Social Security and Medicare contributions that would typically be split with an employer.

Form 1099-NEC reporting adds another layer of complexity. You'll receive 1099s from your brokerage, and if you pay contractors (like photographers or virtual assistants), you'll need to issue 1099s to them as well.

The Real Estate Settlement Procedures Act (RESPA) requires compliance with specific financial practices to prevent fraud and ensure transparency in real estate transactions. While RESPA primarily governs settlement services, realtors should understand how it affects commission payments and disclosure requirements.

Essential Financial Management Practices​

Implementing strong financial habits now will save you stress and money in the long run.

Separate Personal and Business Finances​

Open a dedicated business checking account and use it exclusively for real estate-related transactions. This separation simplifies bookkeeping, makes tax preparation easier, and provides legal protection if your business is ever audited or involved in litigation.

Consider getting a business credit card for business expenses. This creates a clear paper trail and can provide additional benefits like rewards points on your business spending.

Implement a Reliable Tracking System​

Choose a method for tracking income and expenses that you'll actually use consistently. Options range from simple spreadsheets to comprehensive accounting software. The key is consistency—track every transaction, no matter how small.

For mileage tracking, use a dedicated app that leverages GPS to automatically log your trips. Manual mileage logs are time-consuming and easy to forget, but apps make the process seamless.

Maintain Detailed Records​

Keep receipts, invoices, and documentation for every business expense. The IRS requires substantiation for deductions, and good records protect you in case of an audit. Store documents electronically with cloud backup to prevent loss.

For larger purchases or unclear expense categories, make notes about the business purpose. This context helps later when you're preparing taxes or reviewing your finances.

Set Aside Money for Taxes​

A common mistake among new real estate professionals is spending all their commission checks without setting aside money for taxes. As a general rule, reserve 25-30% of your income for tax obligations, including both income tax and self-employment tax.

Transfer this money immediately into a separate savings account designated for taxes. This way, you won't be tempted to spend it, and you'll be prepared when quarterly estimated tax payments are due.

Pay Quarterly Estimated Taxes​

The IRS requires self-employed individuals to make quarterly estimated tax payments if they expect to owe more than $1,000 in taxes for the year. These payments are due April 15, June 15, September 15, and January 15.

Calculate your estimated taxes based on your expected annual income or use the prior year's tax liability as a safe harbor. Missing these payments results in penalties, so set reminders well in advance of each deadline.

Review Your Finances Regularly​

Schedule monthly financial reviews to assess your income, expenses, and progress toward your goals. This regular attention helps you spot problems early, identify spending patterns, and make informed business decisions.

During these reviews, reconcile your bank statements, categorize any unclear transactions, and ensure all income has been properly recorded.

Maximizing Tax Deductions​

Understanding available tax benefits can significantly reduce your tax burden.

The Qualified Business Income Deduction​

Many self-employed real estate professionals qualify for the Qualified Business Income (QBI) deduction, which allows you to deduct up to 20% of your qualified business income. This deduction can result in substantial tax savings, but it comes with income limitations and complex rules.

Consult with a tax professional to determine your eligibility and ensure you're calculating the deduction correctly.

Real Estate Professional Status​

If you meet certain IRS criteria for time spent and participation in real estate activities, you may qualify as a "real estate professional" for tax purposes. This designation can provide significant tax advantages, particularly related to passive activity loss limitations.

The requirements are strict: you must spend more than 750 hours per year in real estate activities and more than half of your working time in real estate. Detailed time logs are essential to substantiate this status.

Retirement Contributions​

As a self-employed individual, you can take advantage of retirement plans designed for small business owners, such as SEP IRAs or Solo 401(k)s. These plans allow you to contribute significantly more than traditional IRAs while reducing your taxable income.

A SEP IRA, for example, allows contributions of up to 25% of your net self-employment income, with a maximum of $69,000 for 2025. These contributions are tax-deductible and grow tax-deferred.

Common Financial Mistakes to Avoid​

Learn from others' mistakes to keep your real estate business financially healthy.

Mixing Personal and Business Expenses​

Using your personal account for business expenses (or vice versa) creates bookkeeping nightmares and can raise red flags during an audit. Maintain strict separation between personal and business finances.

Neglecting to Track Small Expenses​

Those $5 parking fees and$10 meals add up over the course of a year. Small expenses are easy to overlook, but collectively they represent significant deductions. Track everything.

Waiting Until Tax Season​

Don't wait until March or April to organize your financial records. By then, you'll have forgotten important details and will scramble to locate receipts. Stay current with your bookkeeping throughout the year.

Underestimating Tax Obligations​

Many realtors underestimate how much they'll owe in taxes, particularly in their first profitable year. This can lead to unpleasant surprises and financial stress. Always err on the side of setting aside more for taxes rather than less.

Not Seeking Professional Help​

While you can manage basic bookkeeping yourself, tax laws for real estate professionals are complex and change frequently. The cost of hiring a qualified tax professional is typically offset by the additional deductions they find and the penalties they help you avoid.

Planning for Long-Term Success​

Financial management isn't just about surviving tax season—it's about building a sustainable, profitable business.

Build an Emergency Fund​

Aim to save 3-6 months of business and personal expenses in an easily accessible emergency fund. This cushion protects you during slow periods and gives you peace of mind to focus on growing your business rather than stressing about money.

Invest in Your Business Growth​

Set aside a portion of your income for business development. This might include upgrading your marketing materials, investing in better technology, taking advanced training courses, or hiring support staff. Strategic investments in your business can accelerate your growth and income potential.

Monitor Key Performance Indicators​

Track metrics that matter to your business success, such as average commission per transaction, conversion rates, client acquisition costs, and return on marketing investments. These numbers tell the story of your business health and guide strategic decisions.

Plan for Retirement​

Without an employer matching 401(k) contributions, you're solely responsible for your retirement planning. Make retirement savings a priority by automating contributions to your retirement account. Your future self will thank you.

Conclusion​

Financial management might not be the most exciting part of being a realtor, but it's absolutely essential for long-term success. By implementing strong systems, tracking your income and expenses diligently, staying compliant with tax obligations, and planning strategically, you'll build a solid financial foundation for your real estate business.

Remember that the time you invest in financial management pays dividends in reduced stress, lower tax bills, and better business decisions. Whether you handle your finances yourself or work with professionals, make financial management a priority in your real estate practice.

The most successful realtors aren't just great at finding properties—they're also skilled at managing the business side of real estate. Start implementing these practices today, and you'll be well on your way to building a thriving, financially healthy real estate business.

Let's be honest: managing personal finances can feel like a juggling act. From tracking daily spending and budgeting for the month, to saving for big dreams, paying down debt, and trying to grow investments, it's a complex set of tasks. No matter your age, income, or where you live, you've likely encountered frustrating hurdles along the way.

The good news? You're not alone. Many of the challenges you face are widely shared. This post explores some of the most common pain points in personal finance management, looking at why they're so tricky and what strategies people are using to cope.

1. The Scrambled View: Seeing All Your Finances in One Place​

The Pain: Your money lives in many places – a checking account here, a credit card there, a retirement fund somewhere else, maybe even a digital wallet or two. Trying to get a single, clear picture of your overall financial health by logging into multiple apps and websites is time-consuming and frustrating. This fragmentation can lead to missed details and a poor grasp of your true net worth or cash flow. Indeed, studies show over half of consumers would switch financial providers for a more holistic view.

Common Approaches:

• Aggregator Apps: Tools like Empower (formerly Personal Capital), Mint, YNAB, and Monarch promise to bring all your accounts into one dashboard.
• Bank-Provided Aggregation: Some primary banks now offer features to link and view external accounts.
• Manual Spreadsheets: Many still resort to meticulously updating a spreadsheet with balances from each account monthly.
• Logging In Individually: The old-fashioned, one-by-one check-in remains a common, albeit inefficient, habit.

Why It's Still Tough: Despite these solutions, users frequently complain about broken connections requiring re-authentication, incomplete coverage (niche accounts like small regional banks or crypto wallets often don't sync), and data delays. Privacy concerns also prevent some from linking accounts, as over half of people haven't consolidated their accounts digitally due to trust or knowledge gaps.

2. The Budgeting Battle: Creating and Sticking to a Plan​

The Pain: Setting spending limits and actually adhering to them is a classic challenge. Nearly two in five Americans have never had a formal budget, and many who try struggle to maintain it. This can lead to overspending, debt, and anxiety. The pain often stems from budgets feeling restrictive, unexpected expenses derailing plans, or a lack of knowledge on how to create a realistic budget, especially with volatile incomes.

Common Approaches:

• Budgeting Apps: YNAB (You Need A Budget), Mint, Simplifi, and PocketGuard offer various methodologies, from zero-based budgeting to automated tracking with spending alerts.
• Spreadsheets: A go-to for those who want total customization, with about 40% of budgeters using them.
• Cash Envelope Method: A tangible way to control spending by allocating physical cash to envelopes for different expense categories.
• Automated Rules: "Pay yourself first" by auto-transferring to savings, or automating bill payments and spending what's left.
• Financial Coaching & Online Communities: Seeking expert advice or peer support on platforms like Reddit for motivation and tips.

Why It's Still Tough: Budgeting is as much a behavioral challenge as a financial one. Temptation, lifestyle creep, and a lack of financial literacy can undermine even the best intentions. Many apps enforce a specific methodology that doesn't suit everyone, and inaccurate automatic transaction categorization creates tedious manual work.

3. The Mystery of the Missing Money: Tracking Income and Spending​

The Pain: Do you ever get to the end of the month and wonder where a significant chunk of your money went? You're not alone; about 59% of Americans don't track spending regularly. The challenge lies in consistently recording all transactions, especially cash purchases, and categorizing them meaningfully to understand spending habits.

Common Approaches:

• Personal Finance Apps: Most budgeting apps also track expenses by auto-importing transactions from linked bank and card accounts.
• Manual Logs: Using journals, simple expense tracker apps, or even the Japanese Kakeibo method to meticulously record each outlay.
• Periodic Reviews: Instead of daily tracking, some review bank and credit card statements weekly or monthly.
• Specialized Tools: Apps like Expensify for business receipts or subscription trackers for recurring charges.

Why It's Still Tough: Automated categorization is often inaccurate, forcing users to constantly make corrections—a common complaint among Mint users, for example. Cash spending is easily forgotten and rarely captured by apps unless manually entered. Real-time feedback is often lacking, meaning insights arrive too late to influence behavior for that month.

4. The Debt Dilemma: Strategies for Repayment​

The Pain: Managing and reducing debt—be it from credit cards, student loans, or personal loans—is a major source of stress. High interest rates can make it feel like you're running on a treadmill, with much of your payment going to interest rather than principal. In fact, heading into 2025, reducing debt was the top financial goal for 21% of Americans.

Common Approaches:

• Debt Payoff Planning Tools: Apps like Debt Payoff Planner or Undebt.it help visualize payoff schedules using strategies like the debt snowball (paying smallest balances first) or avalanche (highest interest first).
• Consolidation and Refinancing: Taking out a new, lower-interest loan or using a 0% APR balance-transfer credit card to combine multiple debts.
• Manual Strategy Application: Adopting the snowball or avalanche method using spreadsheets or simple lists.
• Automated Extra Payments & Round-Ups: Setting up automatic additional payments or using apps that apply spare change from purchases towards debt.
• Support Communities: Online forums where people share progress and find motivation.

Why It's Still Tough: Many users struggle with understanding how interest accrues. Staying motivated over a long payoff journey is difficult. Existing tools often don't seamlessly integrate debt strategy with overall budgeting, nor do they offer sufficiently personalized advice or robust motivational feedback.

5. The Big Goal Hurdle: Saving for a Large Purchase​

The Pain: Saving for a significant purchase like a home, car, or wedding requires discipline over months or even years. It’s challenging to consistently set aside large sums while balancing daily life and resisting the temptation to dip into those savings.

Common Approaches:

• Dedicated Savings Accounts: Opening separate accounts labeled for specific goals (e.g., "House Fund"). Many online banks offer "buckets" or "pots" for this.
• Automation: Setting up automatic transfers from checking to goal-specific savings accounts each payday.
• Goal-Tracking Apps: Some finance apps allow setting targets and visualizing progress.
• Community Saving Strategies: Informal groups like Rotating Savings and Credit Associations (ROSCAs) are common in some cultures.
• Using Illiquid Forms: Temporarily locking money into short-term CDs or bonds to prevent easy access.

Why It's Still Tough: Maintaining discipline for delayed gratification is hard. Tools often don't integrate goal saving well with monthly budgets or dynamically adjust plans if you fall behind. Managing shared goals with a partner can also be tricky with existing app limitations.

6. The Partner Puzzle: Managing Money with Someone Else​

The Pain: Combining finances with a partner, spouse, or even roommate introduces complexities in coordinating budgets, dividing responsibilities, maintaining transparency, and avoiding conflict. Financial disagreements are a leading cause of relationship stress.

Common Approaches:

• Joint Accounts & Shared Cards: A common method for handling shared household expenses. Often used in a "yours, mine, ours" system with separate personal accounts.
• Expense-Sharing Apps: Tools like Honeydue, Tandem, or Splitwise are designed to help couples or groups track shared expenses and settle up.
• Spreadsheets and Regular "Money Dates": Periodically reviewing finances together to discuss spending, bills, and goals.
• Division of Labor & Allowances: Assigning specific financial tasks to each partner or allocating personal spending money to reduce conflict.

Why It'S Still Tough: Most finance apps are designed for single users. Finding a system that feels fair and transparent to both individuals, especially with differing money personalities or incomes, is a persistent challenge. Tools often lack granular privacy controls or features to facilitate better financial communication beyond just sharing numbers.

7. The Investment Maze: Tracking and Understanding Your Portfolio​

The Pain: As wealth grows, so does the complexity of tracking diverse investments like stocks, bonds, retirement accounts, and crypto spread across multiple platforms. Understanding overall performance, asset allocation, and tax implications can be overwhelming.

Common Approaches:

• Portfolio Aggregator Apps: Services like Empower (Personal Capital) or Kubera aim to consolidate investment data from various accounts.
• Brokerage Consolidation: Minimizing the number of platforms by rolling over old accounts to a single brokerage.
• DIY Spreadsheets: Using tools like Google Sheets with functions (e.g., GOOGLEFINANCE) to manually track holdings and performance.
• Robo-Advisors: Relying on the dashboards provided by automated investment services.
• Specialized Trackers: Tools like Sharesight for detailed performance including dividends, or CoinTracker for crypto.

Why It's Still Tough: No single tool perfectly aggregates every asset type automatically. Calculating true investment performance (factoring in contributions, dividends, fees) is complex. Many tools either oversimplify or overwhelm users with data, and often lack clear educational components or goal integration.

Towards Financial Clarity​

Managing personal finances is an ongoing journey filled with potential pitfalls. While technology offers an ever-increasing array of tools, the core challenges often lie in behavior, knowledge, and finding systems that truly fit individual and shared lives. By understanding these common pain points, we can better identify strategies and seek out or advocate for solutions that bring greater clarity, confidence, and control over our financial well-being. The landscape of financial tools is constantly evolving, hopefully leading to more intuitive, integrated, and genuinely helpful ways to navigate our money.

Small business owners spend an average of 11 hours per month manually categorizing expenses - nearly three full workweeks annually devoted to data entry. A 2023 QuickBooks survey reveals that 68% of business owners rank expense tracking as their most frustrating bookkeeping task, yet only 15% have embraced automation solutions.

Plain text accounting, powered by tools like Beancount, offers a fresh approach to financial management. By combining transparent, programmable architecture with modern AI capabilities, businesses can achieve highly accurate expense categorization while maintaining full control over their data.

This guide will walk you through building an expense automation system tailored to your business's unique patterns. You'll learn why traditional software falls short, how to harness Beancount's plain text foundation, and practical steps for implementing adaptive machine learning models.

The Hidden Costs of Manual Expense Management​

Manual expense categorization drains more than just time—it undermines business potential. Consider the opportunity cost: those hours spent matching receipts to categories could instead fuel business growth, strengthen client relationships, or refine your offerings.

A recent Accounting Today survey found small business owners dedicate 10 hours weekly to bookkeeping tasks. Beyond the time sink, manual processes introduce risks. Take the case of a digital marketing agency that discovered their manual categorization had inflated travel expenses by 20%, distorting their financial planning and decision-making.

Poor financial management remains a leading cause of small business failure, according to the Small Business Administration. Misclassified expenses can mask profitability issues, overlook cost-saving opportunities, and create tax season headaches.

Beancount's Architecture: Where Simplicity Meets Power​

Beancount's plain-text foundation transforms financial data into code, making every transaction trackable and AI-ready. Unlike traditional software trapped in proprietary databases, Beancount's approach enables version control through tools like Git, creating an audit trail for every change.

This open architecture allows seamless integration with programming languages and AI tools. A digital marketing agency reported saving 12 monthly hours through custom scripts that automatically categorize transactions based on their specific business rules.

The plain text format ensures data remains accessible and portable—no vendor lock-in means businesses can adapt as technology evolves. This flexibility, combined with robust automation capabilities, creates a foundation for sophisticated financial management without sacrificing simplicity.

Creating Your Automation Pipeline​

Building an expense automation system with Beancount starts with organizing your financial data. Let's walk through a practical implementation using real examples.

1. Setting Up Your Beancount Structure​

First, establish your account structure and categories:

2025-01-01 open Assets:Business:Checking
2025-01-01 open Expenses:Office:Supplies
2025-01-01 open Expenses:Software:Subscriptions
2025-01-01 open Expenses:Marketing:Advertising
2025-01-01 open Liabilities:CreditCard

2. Creating Automation Rules​

Here's a Python script that demonstrates automatic categorization:

import pandas as pd
from datetime import datetime

def categorize_transaction(description, amount):
    rules = {
        'ADOBE': 'Expenses:Software:Subscriptions',
        'OFFICE DEPOT': 'Expenses:Office:Supplies',
        'FACEBOOK ADS': 'Expenses:Marketing:Advertising'
    }
    
    for vendor, category in rules.items():
        if vendor.lower() in description.lower():
            return category
    return 'Expenses:Uncategorized'

def generate_beancount_entry(row):
    date = row['date'].strftime('%Y-%m-%d')
    desc = row['description']
    amount = abs(float(row['amount']))
    category = categorize_transaction(desc, amount)
    
    return f'''
{date} * "{desc}"
    {category}                               {amount:.2f} USD
    Liabilities:CreditCard                  -{amount:.2f} USD
'''

3. Processing Transactions​

Here's how the automated entries look in your Beancount file:

2025-05-01 * "ADOBE CREATIVE CLOUD"
    Expenses:Software:Subscriptions            52.99 USD
    Liabilities:CreditCard                   -52.99 USD

2025-05-02 * "OFFICE DEPOT #1234 - PRINTER PAPER"
    Expenses:Office:Supplies                  45.67 USD
    Liabilities:CreditCard                   -45.67 USD

2025-05-03 * "FACEBOOK ADS #FB12345"
    Expenses:Marketing:Advertising           250.00 USD
    Liabilities:CreditCard                  -250.00 USD

Testing proves crucial—start with a subset of transactions to verify categorization accuracy. Regular execution through task schedulers can save 10+ hours monthly, freeing you to focus on strategic priorities.

Achieving High Accuracy Through Advanced Techniques​

Let's explore how to combine machine learning with pattern matching for precise categorization.

Pattern Matching with Regular Expressions​

import re

patterns = {
    r'(?i)aws.*cloud': 'Expenses:Cloud:AWS',
    r'(?i)(zoom|slack|notion).*subscription': 'Expenses:Software:Subscriptions',
    r'(?i)(uber|lyft|taxi)': 'Expenses:Travel:Transport',
    r'(?i)(marriott|hilton|airbnb)': 'Expenses:Travel:Accommodation'
}

def regex_categorize(description):
    for pattern, category in patterns.items():
        if re.search(pattern, description):
            return category
    return None

Machine Learning Integration​

from sklearn.feature_extraction.text import TfidfVectorizer
from sklearn.naive_bayes import MultinomialNB
import re
from typing import List, Tuple

class ExpenseClassifier:
    def __init__(self):
        self.vectorizer = TfidfVectorizer()
        self.classifier = MultinomialNB()
    
    def parse_beancount_entries(self, beancount_text: str) -> List[Tuple[str, str]]:
        """Parse Beancount entries into (description, category) pairs."""
        entries = []
        for line in beancount_text.split('\n'):
            # Look for transaction descriptions
            if '* "' in line:
                desc = re.search('"(.+)"', line)
                if desc:
                    description = desc.group(1)
                    # Get the next line which should contain the expense category
                    next_line = next(filter(None, beancount_text.split('\n')[beancount_text.split('\n').index(line)+1:]))
                    if 'Expenses:' in next_line:
                        category = next_line.split()[0].strip()
                        entries.append((description, category))
        return entries
        
    def train(self, beancount_text: str):
        """Train the classifier using Beancount entries."""
        entries = self.parse_beancount_entries(beancount_text)
        if not entries:
            raise ValueError("No valid entries found in training data")
            
        descriptions, categories = zip(*entries)
        X = self.vectorizer.fit_transform(descriptions)
        self.classifier.fit(X, categories)
        
    def predict(self, description: str) -> str:
        """Predict category for a new transaction description."""
        X = self.vectorizer.transform([description])
        return self.classifier.predict(X)[0]

# Example usage with training data:
classifier = ExpenseClassifier()

training_data = """
2025-04-01 * "AWS Cloud Services Monthly Bill" 
    Expenses:Cloud:AWS                         150.00 USD
    Liabilities:CreditCard                   -150.00 USD

2025-04-02 * "Zoom Monthly Subscription"
    Expenses:Software:Subscriptions            14.99 USD
    Liabilities:CreditCard                    -14.99 USD
    
2025-04-03 * "AWS EC2 Instances"
    Expenses:Cloud:AWS                         250.00 USD
    Liabilities:CreditCard                    -250.00 USD

2025-04-04 * "Slack Annual Plan"
    Expenses:Software:Subscriptions           120.00 USD
    Liabilities:CreditCard                   -120.00 USD
"""

# Train the classifier
classifier.train(training_data)

# Test predictions
test_descriptions = [
    "AWS Lambda Services",
    "Zoom Webinar Add-on",
    "Microsoft Teams Subscription"
]

for desc in test_descriptions:
    predicted_category = classifier.predict(desc)
    print(f"Description: {desc}")
    print(f"Predicted Category: {predicted_category}\n")

This implementation includes:

• Proper parsing of Beancount entries
• Training data with multiple examples per category
• Type hints for better code clarity
• Error handling for invalid training data
• Example predictions with similar but unseen transactions

Combining Both Approaches​

2025-05-15 * "AWS Cloud Platform - Monthly Usage"
    Expenses:Cloud:AWS                        234.56 USD
    Liabilities:CreditCard                   -234.56 USD

2025-05-15 * "Uber Trip - Client Meeting"
    Expenses:Travel:Transport                  45.00 USD
    Liabilities:CreditCard                    -45.00 USD

2025-05-16 * "Marriott Hotel - Conference Stay"
    Expenses:Travel:Accommodation             299.99 USD
    Liabilities:CreditCard                   -299.99 USD

This hybrid approach achieves remarkable accuracy by:

1. Using regex for predictable patterns (subscriptions, vendors)
2. Applying ML for complex or new transactions
3. Maintaining a feedback loop for continuous improvement

A tech startup implemented these techniques to automate their expense tracking, reducing manual processing time by 12 hours monthly while maintaining 99% accuracy.

Tracking Impact and Optimization​

Measure your automation success through concrete metrics: time saved, error reduction, and team satisfaction. Track how automation affects broader financial indicators like cash flow accuracy and forecasting reliability.

Random transaction sampling helps verify categorization accuracy. When discrepancies arise, refine your rules or update training data. Analytics tools integrated with Beancount can reveal spending patterns and optimization opportunities previously hidden in manual processes.

Engage with the Beancount community to discover emerging best practices and optimization techniques. Regular refinement ensures your system continues delivering value as your business evolves.

Moving Forward​

Automated plain-text accounting represents a fundamental shift in financial management. Beancount's approach combines human oversight with AI precision, delivering accuracy while maintaining transparency and control.

The benefits extend beyond time savings—think clearer financial insights, reduced errors, and more informed decision-making. Whether you're technically inclined or focused on business growth, this framework offers a path to more efficient financial operations.

Start small, measure carefully, and build on success. Your journey toward automated financial management begins with a single transaction.

Financial fraud costs businesses an average of 5% of their annual revenue, with global losses exceeding $4.7 trillion in 2021. While traditional accounting systems struggle to keep pace with sophisticated financial crimes, plain-text accounting combined with artificial intelligence offers a robust solution for protecting financial integrity.

As organizations move from conventional spreadsheets to plain-text accounting systems like Beancount.io, they're discovering AI's ability to identify subtle patterns and anomalies that even experienced auditors might overlook. Let's explore how this technological integration enhances financial security, examine real-world applications, and provide practical guidance for implementation.

Why Traditional Accounting Falls Short​

Traditional accounting systems, particularly spreadsheets, harbor inherent vulnerabilities. The Association of Certified Fraud Examiners warns that manual processes such as spreadsheets can enable manipulation and lack robust audit trails, making fraud detection challenging even for vigilant teams.

The isolation of traditional systems from other business tools creates blind spots. Real-time analysis becomes cumbersome, leading to delayed fraud detection and potentially significant losses. Plain-text accounting, enhanced by AI monitoring, addresses these weaknesses by providing transparent, traceable records where every transaction can be readily audited.

Understanding AI's Role in Financial Security​

Modern AI algorithms excel at detecting financial anomalies through various techniques:

• Anomaly detection using isolation forests and clustering methods
• Supervised learning from historical fraud cases
• Natural language processing to analyze transaction descriptions
• Continuous learning and adaptation to evolving patterns

A mid-sized tech company recently discovered this firsthand when AI flagged micro-transactions spread across multiple accounts—an embezzlement scheme that had eluded traditional audits. From our firsthand experience, using AI for fraud detection leads to noticeably lower fraud losses compared to relying solely on conventional methods.

Real-World Success Stories​

Consider a retail chain struggling with inventory losses. Traditional audits suggested clerical errors, but AI analysis revealed coordinated fraud by employees manipulating records. The system identified subtle patterns in transaction timing and amounts that pointed to systematic theft.

Another example involves a financial services firm where AI detected irregular payment processing patterns. The system flagged transactions that appeared normal individually but formed suspicious patterns when analyzed collectively. This led to the discovery of a sophisticated money laundering operation that had evaded detection for months.

Implementing AI Detection in Beancount​

To integrate AI fraud detection into your Beancount workflow:

1. Identify specific vulnerability points in your financial processes
2. Select AI tools designed for plain-text environments
3. Train algorithms on your historical transaction data
4. Establish automated cross-referencing with external databases
5. Create clear protocols for investigating AI-flagged anomalies

In our own testing, AI systems reduced fraud investigation time substantially. The key lies in creating a seamless workflow where AI augments rather than replaces human oversight.

Human Expertise Meets Machine Intelligence​

The most effective approach combines AI's processing power with human judgment. While AI excels at pattern recognition and continuous monitoring, human experts provide crucial context and interpretation. A recent Deloitte survey found that companies using this hybrid approach achieved a 42% reduction in financial discrepancies.

Financial professionals play vital roles in:

• Refining AI algorithms
• Investigating flagged transactions
• Distinguishing between legitimate and suspicious patterns
• Developing preventive strategies based on AI insights

Building Stronger Financial Security​

Plain-text accounting with AI fraud detection offers several advantages:

• Transparent, auditable records
• Real-time anomaly detection
• Adaptive learning from new patterns
• Reduced human error
• Comprehensive audit trails

By combining human expertise with AI capabilities, organizations create a robust defense against financial fraud while maintaining transparency and efficiency in their accounting practices.

The integration of AI into plain-text accounting represents a significant advance in financial security. As fraud techniques become more sophisticated, this combination of transparency and intelligent monitoring provides the tools needed to protect financial integrity effectively.

Consider exploring these capabilities within your own organization. The investment in AI-enhanced plain-text accounting could be the difference between detecting fraud early and discovering it too late.

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

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!

Of all the numbers that describe a business, one stands above the rest: net income. It’s the ultimate measure of profitability, the famous "bottom line." But what does it really mean, and how can you track it with precision using a plain-text accounting system like Beancount?

Let's break it down.

What Net Income Really Means​

At its core, net income is the money left over after you’ve paid for absolutely everything required to run your business. This includes the cost of goods sold (COGS), all operating expenses, interest on debt, and taxes.

It’s the clearest single indicator of a company’s financial health. It’s a critical figure for everyone:

• Lenders look at it to gauge your ability to repay loans.
• Investors see it as the source of potential dividends or the capital available for growth.
• Founders rely on it to understand their financial runway and make strategic reinvestment plans.

A positive net income means you’re profitable. A negative one means you’re losing money. It’s that simple.

The Core Formula (Pick the Detail Level You Need)​

You can calculate net income with varying degrees of granularity. The choice depends on how detailed an analysis you need.

• Full Formula: Revenue – COGS – Operating Expenses – Interest – Taxes = Net Income
• Standard Formula: Revenue – COGS – Expenses = Net Income
• Quick & Dirty Formula: Total Revenues – Total Expenses = Net Income

A Quick Tip on Costs: What's the difference between COGS and operating expenses? COGS (Cost of Goods Sold) covers direct costs tied to producing your goods or services (e.g., raw materials, direct labor). Operating Expenses cover everything else that keeps the lights on—salaries, rent, software subscriptions, insurance, etc.

A Mini Example​

Let's make this tangible. Imagine a small coffee roasting business had the following results last month.

Using the full formula, the calculation is straightforward:

$Net;Income =$60,000 - $20,000 -$18,000 - $1,000 -$1,000 = $20,000$

The business generated a true profit of $20,000 for the month.

How to Capture It in Beancount​

Beancount’s structure is perfect for this. By organizing your accounts logically, calculating net income becomes an automatic byproduct of good bookkeeping.

• Tag all revenue under a parent Income account, like Income:Sales or Income:Services.
• Split your expenses to distinguish between direct and indirect costs. Use Expenses:COGS for direct costs and sub-accounts like Expenses:Ops:Salaries or Expenses:Ops:Software for everything else.
• Post interest and taxes to their own accounts (Expenses:Interest, Expenses:Taxes). This makes future analysis, especially for tax preparation, much simpler.
• Balance your books regularly. The fundamental accounting equation, Assets = Liabilities + Equity, must always hold true.

At the end of a period (e.g., a month), you can use balance assertions to confirm the state of your accounts. These entries don't move money; they declare what the balance should be, and bean-check will report an error if it isn't.

; 2025-07-31 Coffee Roaster Enterprises — July close
2025-07-31 balance Assets:Bank:Operating          42000.00 USD
2025-07-31 balance Expenses:COGS                  20000.00 USD
2025-07-31 balance Expenses:Ops                   18000.00 USD
2025-07-31 balance Expenses:Interest               1000.00 USD
2025-07-31 balance Expenses:Taxes                  1000.00 USD
2025-07-31 balance Income:Sales                  -60000.00 USD

One-Line Net Income Query​

This is where the magic happens. With a well-structured ledger, you can calculate your net income for any period with a single command.

bean-query books.beancount \
"SELECT period, sum(number) WHERE account =~ '^(Income|Expenses)' \
  AND year = 2025 GROUP BY month"

This query sums up all values in your Income and Expenses accounts for 2025 and groups them by month. In Beancount, income is represented by negative numbers and expenses by positive ones, so the result will be the negative of your net income.

Even better, you don't even have to run this query manually. Fava, the web interface for Beancount, will plot this automatically for you in its Reports → Income Statement view.

Fast Insights You Can Automate​

Because your ledger is just a text file, you can build powerful automated workflows around it.

• Monthly E-mail Digest: Set up a cron job to run bean-report books.beancount income_statement > net-income.txt and then email the resulting text file to yourself on the first of every month.
• Profitability Alert: Use a Git pre-commit hook that runs a query to check month-to-date profitability. You can program it to refuse the commit if net income is negative, forcing you to acknowledge a losing month.
• Scenario Modeling: Want to stress-test your business? Just copy books.beancount to scenarios/recession.bean, reduce your Income entries by 20%, and rerun your net income query to see the impact instantly.

Key Takeaways​

• Net income is your true bottom line. The goal is to keep it positive and understand its trend over time.
• Beancount makes the underlying math explicit, searchable, and version-controlled. There are no hidden formulas.
• With a disciplined account structure and a single query, you’ll always know whether your business is truly making money.

Why Modern Bookkeeping Matters​

Still managing your investments with spreadsheets? While spreadsheets are versatile, they can become cumbersome and error-prone as your investment portfolio grows. Enter Beancount.io – a sophisticated yet user-friendly investment tracking platform designed specifically for managing stock and cryptocurrency portfolios. Built with engineers and financial minimalists in mind, Beancount.io combines powerful features with an intuitive interface to streamline your investment tracking experience.

Double-entry Bookkeeping: The Foundation of Accuracy​

Beancount.io is built on the principles of double-entry accounting – a time-tested methodology used by financial institutions worldwide. This system ensures mathematical accuracy through a simple yet powerful concept: every financial transaction must balance perfectly.

In double-entry bookkeeping, each transaction requires at least two entries – a debit (+) and a credit (-) – across different accounts. This built-in verification system makes it virtually impossible to record unbalanced transactions, ensuring your financial records remain accurate and reliable.

1970-01-01 open Income:BeancountCorp
1970-01-01 open Assets:Cash
1970-01-01 open Expenses:Food
1970-01-01 open Assets:Receivables:Alice
1970-01-01 open Assets:Receivables:Bob
1970-01-01 open Assets:Receivables:Charlie
1970-01-01 open Liabilities:CreditCard

2019-05-31 * "BeancountCorp" "Salary of May 15th to May 31st"
  Income:BeancountCorp               -888 USD
  Assets:Cash                         888 USD

2019-07-12 * "Popeyes chicken sandwiches" "dinner with Alice, Bob, and Charlie"
  Expenses:Food 20 USD
  Assets:Receivables:Alice 20 USD
  Assets:Receivables:Bob 20 USD
  Assets:Receivables:Charlie 20 USD
  Liabilities:CreditCard -80 USD

As you can see in the two examples above, every transaction must fulfill the accounting equation.

Assets = Liabilities + Equity(aka Net Assets)

We used the Beancount syntax by Martin Blais and the web project Fava by Jakob Schnitzer to build this website. And it will alert you if any transaction has any legs not summing to zero.

Now you understand how we enforce the correctness of the ledger. But you may ask what are those "accounts"?

Understanding Accounts: The Water Bucket Analogy​

Think of your financial accounts as a system of interconnected water buckets, where money flows like water between them. This analogy makes double-entry bookkeeping intuitive: when you transfer money from one account to another, it's like pouring water from one bucket to another – the total amount of water (money) in the system remains constant.

Beancount.io introduces five kinds of accounts.

1. Income — Its amount is always negative or in debit. This is because you are making money, and then the money is debiting from "Income" account and crediting to your "Assets."
2. Expenses — Its amount is always positive or in credit. This is because you are spending money, and the money is flowing from the "Assets" or "Liabilities" to the "Expenses."
3. Liabilities — Its amount is positive or zero. Your credit card liabilities are a good example, which rises and falls in cycles.
4. Assets — Its amount is positive or zero. Your cash or houses are always worth some prices.
5. Equity — Your net assets. The system will calculate automatically for you. Equity = Assets - Liabilities and it reflects how wealthy you are.

Now you can open your customized accounts with those keywords above:

1970-01-01 open Assets:Cash
1970-01-01 open Assets:Stock:Robinhood
1970-01-01 open Assets:Crypto:Coinbase
1970-01-01 open Expenses:Transportation:Taxi
1970-01-01 open Equity:OpeningBalance

Advanced Investment Tracking with Commodities​

Beancount.io excels at tracking diverse investments, from stocks to cryptocurrencies. Let's explore how it handles complex investment scenarios. For example, here's how you would record purchasing 10 Bitcoins at $100 each in 2014:

2014-08-08 * "Buy 10 Bitcoin"
  Assets:Trade:Cash -1000.00 USD
  Assets:Trade:Positions  10 BTC {100.00 USD}

And then three years later, you sell them (originally with costs of $100 per unit annotated with {100.00 USD}) at the price of $10,000 per unit annotated with @ 10,000.00 USD.

2017-12-12 * "Sell 2 Bitcoin"
  Assets:Trade:Positions                   -2 BTC {100.00 USD} @ 10,000.00 USD
  Assets:Trade:Cash                          20,000.00 USD
  Income:Trade:PnL                          -19,800.00 USD

Or the same transaction with @@ 20,000.00 USD means that at the price of $20,000 in total.

2017-12-12 * "Sell 2 Bitcoin"
  Assets:Trade:Positions                   -2 BTC {100.00 USD} @@ 20,000.00 USD
  Assets:Trade:Cash                          20,000.00 USD
  Income:Trade:PnL                          -19,800.00 USD

The sum of all legs of the transaction, including -2 BTC {100.00 USD}, are still, as always, zero.

The costs {100.00 USD} tag is important because you might have bought the same commodity at different costs.

100 BTC {10.00 USD, 2012-08-08}
10 BTC {100.00 USD, 2014-08-08}

If you want to simplify the process, you can set up the account at the beginning with FIFO or LIFO. FIFO stands for first in, first out, while LIFO stands for last in, first out. In the US, IRS uses FIFO to calculate your PnL and tax accordingly.

1970-01-01 open Assets:Trade:Positions "FIFO"

And then when you sell it in shorthand like -2 BTC {}, beancount will apply FIFO strategy automatically and sell the oldest commodity.

Getting Started with Beancount.io​

Beancount.io is a modern cloud-based financial management platform that transforms your text-based transaction records into comprehensive financial statements, including income statements, balance sheets, and trial balances. By combining the reliability of plain text files with powerful visualization tools, Beancount.io helps you maintain precise control over your financial life while gaining valuable insights into your investment performance.

Start your financial journey with Beancount.io - Free during our promotional period!