Complete Guide to FANDAN Financial Report Export: Excel/PDF & Accounting Software Integration

Why It Matters

Managing finances across apartments, homestays, and short-term rentals often consumes significant manpower. The LDRENTING FANDAN Property Manager features a built-in financial report export tool, supporting one-click generation of Excel, PDF, and standard accounting formats. This eliminates tedious manual entry and format conversion. Operators can compress monthly reconciliation from hours into minutes, reducing error rates and labor costs while improving capital transparency. Visit [FANDAN official site](https://store.fandanlock.com) to explore our integrated hardware and software solutions.

Use Cases

This function is designed for property managers, homestay hosts, hotel front desks, and accountants using LDRENTING FANDAN Property Manager or FANDAN PMS. It applies to monthly rent reconciliation, deposit settlement, smart water and electricity meter billing aggregation, audit documentation, and scenarios requiring data synchronization with enterprise accounting systems.

Step-by-Step

Step 1: Log in and Access the Financial Center

• Open Chrome or Edge and log in to the LDRENTING FANDAN Property Manager dashboard with an admin or finance-role account. Two-factor authentication is recommended for financial data security.
• From the left navigation menu, click "Financial Management" and then "Financial Reports." The system displays the current month's summary dashboard, including receivables, actual receipts, and outstanding amounts.

Step 2: Select Report Type and Accounting Period

• At the top of the page, use the "Report Type" dropdown to choose the desired report, such as "Rental Income Details," "Deposit Statement," "Smart Meter Utility Summary," or "Service Fee Statistics."
• Click the "Accounting Period" date picker to quickly switch to "This Month," "Last Month," or "This Quarter," or manually enter a custom range. For cross-year accounts, export by calendar year to maintain Excel performance.

Step 3: Apply Filters to Refine Scope

• In the "Project Filter" area, expand the "City - Property - Building - Floor - Room" hierarchy and select the units to include. Bulk selection and inverse selection are supported for large portfolio operations.
• To include hardware-generated charges, check "Smart Water/Electricity Meter" or "Power Take-off Switch" under "Device Type." The system automatically pulls consumption readings and billing amounts, merging them with rental data.
• Click the blue "Query" button. The table refreshes to show line-item details, with totals and record counts displayed at the bottom for pre-export verification.

Step 4: Export to Excel for Further Processing

• Click the "Export" button at the upper right and select "Export Excel (.xlsx)."
• Choose between "Current Page" or "All Data." For datasets exceeding 10,000 rows, select "Async Export." The system will notify you via internal message when the file is ready.
• Open the downloaded file in Microsoft Office or WPS. It contains a "Summary" sheet with property-level totals and a "Details" sheet showing room number, tenant name, charge type, and linked device IDs (e.g., smart meters), ready for pivot tables or VLOOKUP operations.

Step 5: Export to PDF for Archiving or Printing

• For audit submission or hard-copy filing, click "Export" and choose "Export PDF."
• In the preview dialog, set page orientation to "Portrait" or "Landscape" and enable "Header & Footer." The header auto-populates with the report name and period; the footer shows generation time and page numbering, meeting most corporate archiving standards.
• Click "Confirm Export" to generate a high-resolution vector PDF. Rename the file with a "Property_Period" prefix (e.g., "PropertyA_June2024_Rent") for easy retrieval.

Step 6: Download Standard Format for Accounting Software Integration

• For users of mainstream accounting platforms, click "More" next to "Export" and select "Standard Accounting Format."
• Choose from templates such as "Chart of Accounts Balance (GB2006)" or "Bank Statement Import Template." Common mappings for rental income, deposit liabilities, and utility charges are pre-configured to align with leading financial software field sequences.
• Click "Generate & Download." Then import the file into your accounting software under "Voucher Management" - "Data Import" and follow the wizard to map fields. For custom requirements, configure mappings in advance under "System Settings" - "Account Mapping" to automate long-term reconciliation.

Pro Tips

• Save frequently used filters as templates: After Step 3, click "Save as My Template" and name it (e.g., "Hangzhou - Rent + Utilities"). Next time, load it instantly under "My Templates" to restore building and device selections for recurring monthly exports.
• Cross-platform batch export: If you use both FANDAN PMS and LDRENTING FANDAN Property Manager, switch accounts in "Group View," select multiple projects, and use "Consolidated Export." The system merges financial data from different business lines into a single Excel, eliminating manual aggregation across apartments and homestays.
• Scheduled tasks and auto-delivery: Go to "System Settings" - "Scheduled Tasks" and enable "Auto-Generate Monthly Financial Report." Set it to run at 3:00 AM on the 1st of each month, with PDF and Excel files delivered to a designated email by 9:00 AM. Your finance team can start reconciling immediately upon arrival.
• Highlight anomalies before export: In the report preview, toggle "Anomaly Check" to auto-flag negative deposits or utility spikes. These rows retain red backgrounds in the exported Excel, allowing accountants to prioritize verification and reduce retroactive tracing.
• Customize visible columns: Click the "Gear" icon at the top right to drag-and-drop headers or hide non-essential fields like "Operator" and "Update Time," tailoring the output to your accounting software or auditor requirements.

FAQ

• Export button is unresponsive or grayed out: In 90% of cases, the account lacks "Financial Export" permissions. Ask your super admin to navigate to "Organization" - "Role Permissions," then enable "Report View" and "Data Export" for finance roles. Log out and back in to apply changes.
• Page freezes when exporting large date ranges: When exporting more than 30,000 records or a full year, browser timeouts may occur. Split the period into quarters, or use "Background Async Export." The system will generate the file within 5-10 minutes and send a download link via internal message.
• Accounting software reports missing account codes: This usually happens when your accounting software updates its chart of accounts or adopts secondary codes. Resolve it by rebinding fields like "Rental Income" to the latest account codes in LDRENTING under "Financial Settings" - "Account Mapping," or contact FANDAN technical support for the latest mapping table.

Related Features

Pair financial report exports with FANDAN smart water/electricity meters and power take-off switches for automated utility billing. For public rental housing or talent apartments, FANDAN HOME offers customizable and private deployment options that integrate deeply with financial systems. FANDAN provides one-stop hardware and software services, OEM/ODM manufacturing, and a portfolio of 19+ models including the F15, F25, P40, G20PRO, K3 Access Control, and E5 Card Issuer. Visit [FANDAN official site](https://store.fandanlock.com) for the full product lineup.

Apply for our Get Free Sample program today. Qualified commercial clients are eligible for free samples to experience the seamless integration of FANDAN smart locks and SaaS management platforms. Apply now: [FANDAN official site](https://store.fandanlock.com)