Manage bookkeeping, transactions, and financial reports
Date | Account | Description | Debit | Credit | Balance | Category | Reference |
|---|---|---|---|---|---|---|---|
| 2023-04-07 | Office Supplies | Printer paper and toner | $89.75 | $89.75CR | Expense | PO-2023-0019 | |
| 2023-04-06 | Accounts Receivable | Insurance claim - Robert Wilson | $425.00 | $425.00DR | Revenue | INS-2023-0128 | |
| 2023-04-05 | Salaries | Staff payroll | $4500.00 | $4500.00CR | Expense | PAY-2023-0008 | |
| 2023-04-04 | Cash | Patient payment - Michael Brown | $200.00 | $200.00DR | Revenue | INV-2023-0043 | |
| 2023-04-03 | Utilities | Electricity bill payment | $210.25 | $210.25CR | Expense | UTIL-2023-0004 | |
| 2023-04-02 | Medical Supplies | Restock of examination gloves | $75.50 | $75.50CR | Expense | PO-2023-0018 | |
| 2023-04-01 | Cash | Patient payment - John Smith | $150.00 | $150.00DR | Revenue | INV-2023-0042 | |
| 2023-04-01 | Accounts Receivable | Insurance claim - Sarah Johnson | $350.00 | $350.00DR | Revenue | INS-2023-0127 |
| Patient | Invoice # | Date | Amount | Due Date | Status | Insurance | Days Overdue |
|---|---|---|---|---|---|---|---|
| Sarah Johnson | INV-2023-0040 | 2023-03-28 | $350.00 | 2023-04-27 | Pending | BlueCross | 0 |
| Robert Wilson | INV-2023-0041 | 2023-03-30 | $425.00 | 2023-04-29 | Pending | Medicare | 0 |
| Emily Davis | INV-2023-0039 | 2023-03-25 | $175.00 | 2023-04-24 | Overdue | Self-pay | 3 |
| James Miller | INV-2023-0038 | 2023-03-22 | $290.00 | 2023-04-21 | Overdue | Aetna | 6 |
| Patricia Moore | INV-2023-0037 | 2023-03-20 | $150.00 | 2023-04-19 | Overdue | Self-pay | 8 |
| Category | YTD | Change |
|---|---|---|
| Medical Supplies | $3250.75 | 12.5% |
| Office Rent | $7500.00 | 0% |
| Utilities | $1875.45 | 5.2% |
| Professional Development | $1250.00 | 8.3% |
| Software | $3499.99 | 15% |
| Office Supplies | $875.25 | 3.7% |
| Insurance | $4250.00 | 0% |
| Date | Description | Amount | Type | Status | Reference | |
|---|---|---|---|---|---|---|
| 2023-04-01 | Deposit - Patient payments | $350.00 | Credit | Cleared | DEP-2023-0015 | |
| 2023-04-02 | Check - Medical Supplies Co. | $750.00 | Debit | Cleared | CHK-2023-0042 | |
| 2023-04-03 | ACH - City Power & Light | $210.25 | Debit | Cleared | ACH-2023-0018 | |
| 2023-04-04 | Deposit - Insurance payment | $1250.00 | Credit | Pending | DEP-2023-0016 | |
| 2023-04-05 | ACH - Staff payroll | $4500.00 | Debit | Cleared | ACH-2023-0019 | |
| 2023-04-06 | Check - Office Depot | $89.75 | Debit | Pending | CHK-2023-0043 | |
| 2023-04-07 | Deposit - Patient payments | $425.00 | Credit | Pending | DEP-2023-0017 |
Generate audit-ready financial reports with complete transaction history and documentation.