SleekView for WP ERP Accounting: invoices, payments & ledgers as tables
WP ERP Accounting stores invoices in wp_erp_acct_invoices, payments in wp_erp_acct_invoice_receipts and double-entry ledger rows in wp_erp_acct_journals. SleekView reads those tables so AR, AP and bookkeeping ops work from one filterable workspace.
♾️ Lifetime License available
Bookkeeping in a real working table
WP ERP Accounting persists invoices in wp_erp_acct_invoices with line items in wp_erp_acct_invoice_details, payments in wp_erp_acct_invoice_receipts and double-entry ledger rows in wp_erp_acct_journals linked to ledger accounts in wp_erp_acct_ledgers. The default Accounting UI ships per-screen views for invoices, bills and chart of accounts, which is appropriate for entering records and limited the moment a controller needs an aging report across all open invoices joined to customer status.
SleekView reads those tables directly. An AR view joins wp_erp_acct_invoices with wp_erp_peoples for customer name, aggregates wp_erp_acct_invoice_receipts for amount paid, and shows due date, status and outstanding amount as sortable columns. Ledger views read wp_erp_acct_journals for double-entry exploration filterable by account and date.
Inline edits go through WP ERP Accounting's functions where supported, so payment recording and status changes call the same hooks the default UI fires. The double-entry integrity stays intact because nothing bypasses the plugin's data layer; SleekView just gives bookkeepers a real working table.
Workflow
AR, AP and ledger from one workspace
Connect Accounting tables
wp_erp_acct_invoices, wp_erp_acct_invoice_receipts and wp_erp_acct_journals. The agent offers ready joins to wp_erp_peoples for customer and vendor names.
Compose AR and AP views
Build a ledger view
wp_erp_acct_journals page filterable by ledger account and date. Drill into linked invoice or payment from any journal row.
Edit through Accounting hooks
Sample columns
A typical WP ERP Accounting AR view
wp_erp_acct_invoices and joins wp_erp_peoples plus aggregates wp_erp_acct_invoice_receipts for amount paid.
wp_erp_acct_invoices + wp_erp_acct_invoice_receipts + wp_erp_acct_journals
| Invoice | Customer | Status | Total | Outstanding | Due date |
|---|---|---|---|---|---|
| INV 1024 | Reiter Studio | Paid | £1,840.00 | £0.00 | Apr 24 |
| INV 1025 | Patel Design | Partial | £640.00 | £240.00 | Apr 30 |
| INV 1026 | Hello Dev Ltd | Paid | £312.00 | £0.00 | Apr 18 |
| INV 1027 | Brew Coop | Overdue | £480.00 | £480.00 | Mar 09 |
Comparison
Default WP ERP Accounting admin vs SleekView
Default WP ERP Accounting admin
- Invoice list and payment list live on separate screens with no aggregated outstanding column
- Aging buckets are not exposed as a filter or sortable column in the default UI
-
Custom
wp_erp_acct_invoicesmeta is not pivoted into typed columns -
Ledger exploration through
wp_erp_acct_journalsrequires per-account drill-in - Bulk send reminder or bulk apply discount across a filtered cohort requires per-row clicks
SleekView
-
Read directly from
wp_erp_acct_invoiceswith aggregatedwp_erp_acct_invoice_receiptsfor paid amount - Surface aging buckets as filters and sortable columns
- Filter on status, customer, due date and outstanding amount together
- Inline-edit status, due date and notes via WP ERP Accounting hooks
- Tabbed SleekView pages for invoices, bills, payments and ledger journals
Features
What SleekView gives you for WP ERP Accounting Module
AR with aging buckets
Combine wp_erp_acct_invoices status with aggregated wp_erp_acct_invoice_receipts for outstanding amount. Filter by aging bucket and customer to focus AR follow-up.
Bills and payments side by side
wp_erp_acct_bills with payments aggregated as a paid column gives AP a working view. Filter overdue bills by vendor and due date in one table.
Ledger exploration
Build a wp_erp_acct_journals view filterable by ledger account and date. Drill from a row into the linked invoice or payment for full audit context.
Audience
Who uses SleekView for WP ERP Accounting
Accounts receivable
Filter open invoices by aging bucket and customer to plan collection calls. Bulk-send reminders from a filtered view through WP ERP Accounting hooks.
Accounts payable
Filter bills by vendor and due date for payment runs. Inline-edit due date or status from the row without opening per-bill screens.
Controllers and auditors
Build a wp_erp_acct_journals view filtered by ledger account and date range. Audit balances and drill from journal row into the linked invoice for context.
The bigger picture
Why bookkeeping needs a working table
WP ERP Accounting models invoices, payments and bills with proper double-entry journals because that is the only way to keep books that survive audit. The schema is purpose-built for joins between invoices, receipts and ledger accounts. The default Accounting UI focuses on entering records and per-screen lists, which is the right shape for data entry and limited for cross-document operational reporting.
Aging reports, ledger account exploration and AR follow-up cohorts need a different view shape. SleekView reads wp_erp_acct_invoices, wp_erp_acct_invoice_receipts and wp_erp_acct_journals directly with the joins those questions need. Aging buckets appear as filters.
Outstanding amount appears as a sortable column. Bulk reminders route through WP ERP Accounting's own functions so double-entry stays balanced and customer notifications fire correctly. Controllers get ledger views, AR gets aging cohorts, AP gets payment runs by vendor.
The accounting schema is already structured for this work; SleekView is the table layer that uses it.
Questions
Common questions about SleekView for WP ERP Accounting Module
Invoices in wp_erp_acct_invoices with line items in wp_erp_acct_invoice_details. Payments in wp_erp_acct_invoice_receipts. Ledger rows in wp_erp_acct_journals. SleekView reads those directly with joins to wp_erp_peoples for customer name.
Yes. SleekView computes aging from wp_erp_acct_invoices.due_date and the open balance derived from receipts. Filter on aging bucket and sort by oldest outstanding to focus AR work.
Yes. Writes route through WP ERP Accounting's invoice and payment functions so ledger rows in wp_erp_acct_journals stay balanced. Nothing bypasses the plugin's data layer.
Yes. Build a dedicated SleekView page over wp_erp_acct_journals with a filter on ledger account id. Drill from a journal row into the linked invoice or payment for full context.
Yes. wp_erp_acct_bills joins to vendors in wp_erp_peoples with payments aggregated for paid amount. AP teams get the same working table shape AR uses.
Yes. Select a filtered set and run the bulk reminder action. SleekView calls WP ERP Accounting's reminder function per row so customer notifications fire and the activity log updates.
Yes. SleekView paginates server-side and uses indexes on wp_erp_acct_invoices and wp_erp_acct_journals. Hundreds of thousands of journal rows with date and account filters render quickly.
Yes. Filter to the period and accounts under audit and export the row set as CSV. Includes invoice, receipt aggregates and joined customer context in one file.
Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Woocommerce Frontend Manager
- Thrivecart Funnels
- Stitchlabs Wp
- Woocommerce Elavon
- Funnelkit Funnel Builder
- Wpc Product Bundles
- Woocommerce Name Your Deal
- Woocommerce Product Variations Swatches
- Woocommerce Print Invoices
- Magento Bridge
- Woocommerce Stock Sync
- Woocommerce Google Product Feed
- Yith Woocommerce Gift Cards
- Rehub Affiliate
- Woocommerce Google Analytics Pro