Mario's Receivables

Accounts Receivable

Enter your Firebase credentials to connect. Get these from console.firebase.google.com → Project Settings → Your apps.

Firebase Configuration

⚙️ After connecting, sign in with your Firebase Auth email. Enable Email/Password auth in Firebase Console → Authentication.

—

Total Receivables

—

Total Collected

—

Balance Due

—

Invoices

—

Unpaid

Branch Summary

Recent Payments

Invoices

All Baguio Clark QC Unpaid Paid

Statement of Accounts

All Branches Baguio Clark QC

Payment History

All Baguio Clark QC

Add Invoice

Invoice #

Branch

Invoice Date

Amount

Payment Received (optional)

Payment Date (optional)

Record Payment

Invoice #—

—

Payment Amount

Payment Date

Delete Invoice

Are you sure you want to delete invoice #—? This cannot be undone.

Export to Excel

Choose what to include in your spreadsheet. Each selection becomes a separate sheet.

All Invoices

Every invoice with status, amounts & payment dates

Branch Summary

Totals per branch: receivable, collected, balance

Baguio SOA

Statement of accounts for Baguio branch

Clark SOA

Statement of accounts for Clark branch

QC SOA

Statement of accounts for Quezon City branch

Payment History

All recorded payments sorted by date

Filename

🔄 Re-sync from Spreadsheet

This will update all existing invoices in Firebase with the latest data from the built-in spreadsheet, and add any new invoices. Your manually added invoices will not be deleted.

⚠️ This will overwrite payment data for invoices that exist in the spreadsheet. Manually recorded payments on those invoices will be replaced.

🖨 Generate Unpaid SOA

Select a branch to generate a professional statement showing all unpaid invoices.

AccountsReceivable

Sign In

Accounts
Receivable