# Get your Restaurant365 AP and P&L data through an API > Read AP transactions, the Profit and Loss report and bank reconciliation balances from Restaurant365 with one API call each. A workflow can email you the unapproved AP invoices every morning and post each location's P&L to your system every Monday. Page: https://fous.com/automate/restaurant365 Updated: 2026-11-12 Works with your own Restaurant365 account. Fous is an independent product. ## What you can build on R365 ### Get AP transactions Reads the AP Transactions page under Accounting > Accounts Payable, filtered by location, vendor, date and Approval Status. - Takes: Location (optional), vendor (optional), from date, to date, approval status (optional) - Returns: Number, transaction type, vendor, location, date, due date, amount, amount remaining, approval status, current approver, payment method ### Run the Profit and Loss report Runs Profit and Loss from My Reports in the Reports app with the Report Type, As Of date and location filter you give, and reads every GL account row. - Takes: Report type, as of date, filter by, filter, detail level - Returns: GL account, actual, budget, prior year, variance, YTD actual, guest count, guest check average ### Check bank reconciliation balances Runs the Bank to GL Reconciliation report for one bank account and reads each reconciliation's balances and difference. - Takes: Bank account, show (all reconciliations or only out of balance) - Returns: Date, beginning balance, withdrawal total, deposit total, ending balance, end bal + uncleared, GL balance, difference, balance comment ### Approve an AP invoice Opens an AP invoice from AP Transactions in the AP Invoice Form and selects Approve & Close, if your user has the Approve AP Invoices permission. - Takes: Invoice number, vendor - Returns: Invoice number, vendor, amount, approval status, approved by, approved on ## Automate R365 with a workflow A [workflow](/product/workflows) runs your methods as one process, with nobody at the screen. A schedule or a call from your own system starts it, the steps run in order, and the result arrives in your inbox or in the systems you already use. ### Unapproved AP invoices due this week, by location Starts: Every weekday at 7:00 1. Get the AP transactions with Approval Status Unapproved and transaction type AP Invoice. 2. Keep the invoices with a due date in the next seven days. 3. Email you the list grouped by location, with vendor, number, due date, amount and current approver. ### Weekly Profit and Loss for each location Starts: Every Monday at 8:00 1. For each location you name, run the Profit and Loss report as of the last day of the prior week. 2. Summarize the accounts where the variance against budget is largest. 3. Post the rows and the summary to your webhook, one message per location. ### Out-of-balance bank reconciliations, every account Starts: Every month on the 5th at 9:00 1. For each bank account you name, run Bank to GL Reconciliation with Show set to only out of balance. 2. Stop when no account has a row with a difference. 3. Email you each out-of-balance row with its date, GL balance, difference and balance comment. You can run a workflow by hand on every plan, Free included. Schedules and webhook triggers come with the paid plans, from $29 a month. ## Once built, one call from your code Once you have built a [method](/product/methods), it is one POST to /v1/runs from your backend, or a tool an AI agent calls over MCP. This is what “Get AP transactions” would look like. Example request: ``` curl https://api.fous.com/v1/runs \ -H "Authorization: Bearer $FOUS_API_KEY" \ -H "Content-Type: application/json" \ -d '{ "method": "restaurant365.com/get_ap_transactions", "input": { "location": "Northwind Grill Downtown", "from_date": "2026-11-01", "to_date": "2026-11-11", "approval_status": "Unapproved" } }' ``` Example response: ``` { "status": "completed", "data": { "transactions": [ { "number": "INV-58213", "transaction_type": "AP Invoice", "vendor": "Acme Produce", "location": "Northwind Grill Downtown", "date": "2026-11-09", "due_date": "2026-11-23", "amount": 2480.15, "amount_remaining": 2480.15, "approval_status": "Unapproved", "current_approver": "AP Manager", "payment_method": "Check" } ], "count": 1 } } ``` An example with invented data, not a ready-made endpoint. The method exists in your organization once you build it, and its name, inputs and fields follow your request. ## R365’s own options R365's Public API reads and writes across Accounting, Inventory and Sales, but it is open only to a closed Early Adopter group, with no new participants for now. Customers can connect reporting tools to the OData Connector, and the older Classic API is read-only. On the site itself, AP Transactions exports to .csv and reports can be exported, emailed or printed. | Option | What it covers | What it takes | | --- | --- | --- | | R365 Public API | Reads and writes across major product areas such as Accounting, Inventory and Sales, under /public/v1/{domain}/{resource}. | A place in the Early Adopter group, which is closed to new participants. Credentials are a long-lived bearer token issued after approval. | | OData Connector | Pulls GL accounts, transactions, transaction details, locations, items, labor and sales data into Excel, Power BI, Domo or Prophix. | A user with the Accounting Clerk or Full Access role. Sales endpoints return up to 31 days per request, and some endpoints are throttled. | | Secure Data Share | Direct, read-only access to R365 data through Snowflake. | Access through Snowflake. R365 lists it as a current option on its API access page. | | R365 by hand | AP Transactions, approvals on the AP Invoice Form and reports in My Reports. Tables export to .csv; reports can be exported, emailed or printed. | An R365 user with the permissions for each page, signed in at your company's instance URL. | Read on November 12, 2026: [Request access to the R365 Public API](https://docs.restaurant365.com/apidocs/request-access), [Restaurant365 OData Connector](https://docs.restaurant365.com/docs/restaurant365-odata-connector-1), [AP Transactions page](https://docs.restaurant365.com/docs/ap-transactions). ## Signing in to R365 R365 signs you in at your company's own instance URL, such as yourcompany.restaurant365.com, with a username and password that are case-sensitive, or with the SSO sign-in option when your organization has set it up. With Fous you sign in once through R365's own sign-in with your own account: the login is sealed with AES-256, never shown to code or agents, and an expired session is signed back in. ## Worth knowing - **Location Access decides what a user sees**: An R365 administrator assigns each user a User Role and Location Access, and a user without them sees no data. Use an account that covers every location you want a method to return. - **Sales arrive after the Daily Sales Summary**: R365's sales and labor data are current only after the Daily Sales Summary is polled. Schedule a workflow that reads sales, such as the weekly P&L, for after that has run. - **Who may approve an AP invoice**: Approving needs the Approve AP Invoices permission. A user with only Food > AP Invoices > Approve can approve only invoices in Completed status, and Unapprove appears only when Allow the Unapproval of Transactions is on. - **One instance, one user, ten tries**: Each R365 database, or instance, and each user in it is unique, and signing in to the wrong one fails. After 10 failed login attempts R365 locks the account for a while, longer with each further failure. ## More in Food service, restaurants and alcohol - [SGWS Proof](https://fous.com/automate/sgws-proof.md) - [Provi](https://fous.com/automate/provi.md) - [myCoke](https://fous.com/automate/mycoke.md) - [BEES](https://fous.com/automate/bees.md) - [METRO Online-Kundenkonto](https://fous.com/automate/metro-online-kundenkonto.md) - [Sligro](https://fous.com/automate/sligro.md) - [Deliveroo Partner Hub](https://fous.com/automate/deliveroo-partner-hub.md) - [DoorDash Merchant Portal](https://fous.com/automate/doordash-merchant-portal.md) - [foodpanda Partner Portal](https://fous.com/automate/foodpanda-partner-portal.md) - [Glovo Manager Portal](https://fous.com/automate/glovo-manager-portal.md) - [GrabMerchant](https://fous.com/automate/grabmerchant.md) - [Grubhub for Restaurants](https://fous.com/automate/grubhub-for-restaurants.md) - [iFood Portal do Parceiro](https://fous.com/automate/ifood-portal-do-parceiro.md) - [Just Eat Partner Hub](https://fous.com/automate/just-eat-partner-hub.md) - [PedidosYa Partner Portal](https://fous.com/automate/pedidosya-partner-portal.md) - [Rappi Aliados](https://fous.com/automate/rappi-aliados.md) - [Swiggy Partner](https://fous.com/automate/swiggy-partner.md) - [Uber Eats Manager](https://fous.com/automate/uber-eats-manager.md) - [Wolt Merchant Portal](https://fous.com/automate/wolt-merchant-portal.md) - [Zomato Restaurant Partner](https://fous.com/automate/zomato-restaurant-partner.md) - [饿了么商家版](https://fous.com/automate/ele-me-merchant-backend.md) - [배민셀프서비스](https://fous.com/automate/baemin-self-service.md) - [Gordon Ordering](https://fous.com/automate/gordon-ordering.md) - [PFG CustomerFirst](https://fous.com/automate/pfg-customerfirst.md) - [Sysco Shop](https://fous.com/automate/sysco-shop.md) - [US Foods MOXē](https://fous.com/automate/us-foods-moxe.md) - [Bidfood Direct](https://fous.com/automate/bidfood-direct.md) - [Brakes](https://fous.com/automate/brakes.md) - [Transgourmet Webshop](https://fous.com/automate/transgourmet-webshop.md) - [レストランボード](https://fous.com/automate/restaurant-board.md) - [OpenTable GuestCenter](https://fous.com/automate/opentable-guestcenter.md) - [TheFork Manager](https://fous.com/automate/thefork-manager.md) - [食べログ店舗管理画面](https://fous.com/automate/tabelog-owner-admin.md) - [Oracle MICROS Simphony Reporting & Analytics](https://fous.com/automate/oracle-micros-simphony-reporting-and-analytics.md) - [Toast Web](https://fous.com/automate/toast-web.md) - [Insights C3M](https://fous.com/automate/insights-c3m.md) Other industries: [SinglePoint](/automate/singlepoint), [Comdata iConnectData](/automate/comdata-iconnectdata), [myIR](/automate/myir), [GST Portal](/automate/gst-portal), [Amadeus Selling Platform Connect](/automate/amadeus-selling-platform-connect), [Simplificación Registral](/automate/simplificacion-registral). ## Frequently asked questions ### Does Restaurant365 have an API? Yes, but its read and write Public API is open only to a closed Early Adopter group, which is not taking new participants. Other customers can use the OData Connector for reporting tools, the read-only Classic API, or Secure Data Share through Snowflake. The Classic API and Secure Data Share are read-only. ### Can I get R365 AP invoices into a spreadsheet or another system? Yes. The AP Transactions page exports its table to a .csv file, with columns such as Location, Vendor, Number, Due Date, Amount and Current Approver. With Fous, a method returns the same rows as JSON and a workflow can send them to your webhook on a schedule. ### Can I pull the R365 Profit and Loss report automatically? Yes, with a method you build in Fous: it runs Profit and Loss with the Report Type, As Of date and location filter you give and returns each GL account's figures as JSON, and a workflow can run it every week. In R365 itself, the Run drop-down in My Reports exports, emails or prints a report. ### Who can use the R365 OData Connector? Users with the Accounting Clerk or Full Access default role. R365 suggests a dedicated connector user, since a personal profile only returns the locations in that user's Location Access. Sales endpoints return up to 31 days per request. ### Is Fous affiliated with Restaurant365? No. Fous is an independent product. You use it with your own Restaurant365 account, and a method reads and does only what that account can. Fous is an independent product: it is not affiliated with, endorsed by or sponsored by the operator of Restaurant365 (Restaurant365). The name is used only to say which system this page is about. Something here wrong or out of date? Write to legal@fous.com.