Setting Up Vendors & Contacts: Tracking Repairs & 1099s

In property management, you routinely pay independent contractors, utility companies, and insurance brokers. If you manage these payments by creating custom ledger accounts for Bob the Plumber or Jane the Cleaner, your Chart of Accounts becomes bloated.

Mogul Books solves this by keeping a standardized Chart of Accounts and tracking payees using the Vendor Dimension. This document explains how to set up vendors, associate transaction payouts, and manage 1099 tax compliance.

Why Vendors Are a Dimension

By tracking payees as a metadata dimension rather than an account name, you keep your ledger standardized:

• All handyman payments go to the same account: 5010 - Repairs & Maintenance.
• All cleaning bills go to: 5020 - Cleaning.
• Each transaction line is tagged with a nullable vendor_id.

This keeps your Profit & Loss statements clean for your CPA, while allowing you to run detailed payout reports by vendor (e.g., "How much did I pay Bob's Plumbing LLC this year?").

Step 1: Registering a Vendor

To add a vendor to your contact book:

1. Navigate to the Setup Console and select the Vendors & Payees tab.

2. Click + Add Vendor.

3. Fill in the profile fields:

• Vendor Name: Business or individual name (e.g., "Apex Plumbing").
• Default Category: The standard GL account this vendor maps to (e.g., selecting 5010 - Repairs & Maintenance for a plumber. Mogul Books will auto-suggest this category for future transactions).
• Tax Info: Taxpayer Identification Number (TIN/EIN) or SSN.
• 1099-NEC Eligible: Check this box if the payee is an unincorporated independent contractor.

Step 2: Form 1099-NEC Tax Compliance

The IRS requires businesses to file Form 1099-NEC for any unincorporated service provider paid $600 or more in a tax year. Failing to file 1099s can lead to IRS penalties.

Mogul Books automates this compliance tracking:

1. Cumulative Ledger Review: Mogul Books tracks all debit balances posted to expense accounts where the vendor_id is flagged as 1099 Eligible.

2. Threshold Alerts: As year-end approaches, Mogul Books flags any eligible vendors who have exceeded the $600 payout threshold.

3. W-9 Collection: You can store filled W-9 PDFs directly inside the vendor profile.

4. CPA Export: During tax preparation, your CPA can export a pre-compiled 1099-NEC package containing payees, tax IDs, addresses, and exact payout amounts.

AI Category Mapping

Mogul Books' transaction matching engine learns from your vendor setup. When a bank fee is imported (e.g., "Lowes Home Centers #3421"):

1. The system matches the string to your vendor Lowe's.

2. It looks up Lowe's default category.

3. It pre-fills the entry form with Lowe's and 5010 - Repairs & Maintenance (or flags it for capitalization if the amount exceeds $2,500).

This eliminates repetitive dropdown clicks, allowing you to reconcile home improvement transactions in seconds.