Die Hilfe ist vorerst auf Englisch

Abschnitte

Hilfe / Daybook

Why#

A profit and loss report in the restaurant owner's format, built from Syrve automatically: for a day, a week, a month or a year. The same screen shows what the report is missing and what to do to make the numbers complete.

Where to find it#

«Daybook» → «Daily PnL».

Screenshotside menu, «Daybook» group, «Daily PnL» item highlighted

The item is visible if the member has the «Daily PnL» section open in user rights. The section is part of the Daybook Start package.

What is on the screen#

At the top, a strip of tabs:

  • «Report» - the PnL itself, opens by default.
  • «Forecast» - month revenue forecast and plan. Part of Daybook Pro; the tab is missing if the «Forecast» section is not open for the company or your role.
  • «Contracts» - an empty tab for now: «No contracts», the «Add contract» button is inactive.
  • «Edit log» - Syrve documents that changed after we read them. The number next to it is how many edits of the month are waiting for a decision.

On the right of the strip:

  • «Settings» - opens «Daybook settings» on the «Articles and sources» section.
  • «Public link» - only for the company owner.

On the «Report» tab, top to bottom:

  • Switches: horizon «Day», «Week», «Month», «Year»; period with ‹ › arrows; split «Bar + kitchen» or «Total only» (if the company has departments set up). On the right, the recompute button ↻ and the check shield.
  • Banner «Syrve document edits in <month> without a decision: N - ±X € to cost of goods» with the link «Edit log →». Shown only when there are such edits.
  • Banner «Not all Syrve accounts are assigned to P&L articles: N» with the «Assign →» button. Shown only when there are such accounts.
  • Period cards: «Day», «Week», «Month» - till revenue and a bar showing how many days of the period are already in the data («6 of 7»). The day has a chip «In progress», «Closed» or «no data».
  • Tiles «Gross profit», «Food cost», «Staff», «Result».
  • «What to do» card - up to a few actions to make the report complete, with an «Open … →» or «Message the agent» button. Nothing to do - «Nothing to do right now.»
  • Report table: «Article», department columns, «Total», «%», comparison with the previous period, «Src». Daybook Pro adds the «Goal» and «To goal» columns.
  • Chart: for a day - «Last 7 days», for a week - «Days of the week», for a month - «Days of the month». The bars are till revenue.

On the «Year» horizon there are no cards or tiles: instead, «What to do», the table «PnL <year> by month» (articles in rows, months in columns) and the «Months of the year» chart.

Screenshot«Daily PnL» screen, «Report» tab, «Month» horizon, switches, shield and «What to do» card highlighted

How to#

Choose a period#

  1. Click «Day», «Week», «Month» or «Year».
  2. Use the ‹ › arrows to go to the period you need. A future period does not open.
  3. If the company has departments set up, choose «Bar + kitchen» (a column per department) or «Total only».

The choice is kept in the page address: you can send a link to this view to a colleague with access to the company.

Check whether you can rely on the numbers#

The shield colour is visible right away:

  • green - «Check passed and matched»;
  • yellow - «Not reliable to the cent»: the report is calculated, but there are estimates or unchecked parts;
  • red - «Report incomplete»: a source is missing.
  1. Click the shield. «Integrity check - run report» opens with the check text.
  2. «Check again» - run the check once more.
  3. «+ invariant» - also reconcile the two cost methods for months with a stock count. It takes a few seconds per month.
  4. «Copy» - copy the report text, for example to send to the accountant.

On the «Year» horizon the shield checks the last month that has data.

Screenshotopen shield, «Integrity check - run report» panel, «Check again», «+ invariant», «Copy» buttons highlighted

Refresh report data#

If a stock count was entered in Syrve retroactively or documents were corrected, you do not need to wait for the nightly recompute.

  1. Click ↻ to the left of the shield.
  2. «Recomputing the month…» appears next to it, then the result in words. On the «Year» horizon all started months are recomputed one by one: «Recomputing: May, 5 of 9».

The button is available to a member with write rights in «Daily PnL».

Assign Syrve accounts to articles#

  1. On the banner «Not all Syrve accounts are assigned to P&L articles», click «Assign →».
  2. The «Not assigned: N» window opens: «Syrve account», «Amount» for the period, «Suggestion» and «Action».
  3. For each account choose:
    • «Accept» - put it into the suggested article;
    • «Choose another article» - pick an article from the list and click «Assign»;
    • «Exclude» - enter a reason and click «Save». An exclusion without a reason is not saved.
  4. The full chart of accounts is behind the «Chart of accounts →» link in the window.

A suggestion marked «(not certain, a person decides)» is not applied by the system. The company owner can change account assignments.

Screenshot«Not assigned: N» window, «Suggestion» column and «Accept», «Choose another article», «Exclude» buttons highlighted

View the forecast and set the month plan#

  1. Open the «Forecast» tab. Choose the month with the ‹ › arrows.
  2. Warnings may appear at the top: «The forecast has nothing to learn from» (6 weeks of sales are needed), «Closed days not taken into account» or «Holidays not taken into account» with the «Opening hours →» and «Holidays →» buttons. Fill in the schedule and holidays so the forecast takes them into account.
  3. In the «Month plan» row, enter the amount in euros and click «Save plan». A member with write rights in «Forecast» can save the plan.
  4. Below: cards «Revenue», «Cost by recipe cards», «Losses beyond recipe cards», «Month result», «Missed»; the «By day» chart (actual, forecast, days below the spread, holidays, closed days); «Accuracy» on history; «How it is calculated»; «Top of P&L» with plan and difference; «Missed revenue» with the «Open day» button.

Only revenue is forecast. Cost, losses and result show «nothing to estimate with», bookings are not taken into account in the forecast.

Screenshot«Forecast» tab, top cards, «Month plan» row and «By day» chart highlighted

Review Syrve document edits#

  1. Open the «Edit log» tab or click «Edit log →» on the report banner. The previous month opens by default.
  2. At the top: month ‹ ›, warehouse («All» or a specific one), chip «open until <date>» or «closed <date>», mode «edits automatically» or «edits manually», link «Settings →». A closed month has the filter «All edits» / «After closing».
  3. Month totals: «Edits», «After closing», «Without decision», «Cost shift».
  4. Each table row is a Syrve document. Click › or the document number to see the items: product, quantity and amount «before - after».
  5. For a document without a decision click:
    • «Accept» - the edit goes into the report; if it is not in the numbers yet, the month is recomputed overnight;
    • «Revert» and confirm - a task is created for the stock keeper to roll the document back in Syrve.

No edits - «Month documents have not changed since reading». The «Automatically» or «Manually» mode is set in «Daybook settings» → «Syrve document edits».

Screenshot«Edit log» tab, one document expanded, «Accept» and «Revert» buttons highlighted

The button is available only to the company owner.

  1. Choose the horizon, period and split: the link gives exactly this report.
  2. Click «Public link». The link is created right away, valid for 7 days.
  3. Click the copy button next to the address and send the link.
  4. To revoke - the × button next to the address, then «Revoke». Everyone who has the link loses access immediately.

The link shows only the report for the chosen period, without contracts and settings. The address is shown once: after the screen reloads, the panel says «A link to this report has already been issued» and offers «Revoke link» or «Issue a new one».

To make the link open only for people with access to the company, choose «Require login» in «Daybook settings» → «Horizon and where to send». This also applies to links already issued.

Screenshot«Public link» panel with a created link, copy and revoke buttons and the «Valid until» line highlighted

Set up articles and sources#

  1. Click «Settings» in the tab strip. «Daybook settings» → «Articles and sources» opens.
  2. At the top: the «Upload P&L (Excel)» block, the chart of accounts state («company chart of accounts, revision N» or «company chart of accounts is not set up») and the table «Row», «Form article», «Source» («Syrve», «Accounting», «Manual», «none») for the last closed month.
  3. Below, the Syrve account mapping:
    • «Suggestion: write-off accounts to articles» - «Accept», «Postpone» or «Accept all (N)»;
    • «No postings in <month>: N» - accounts without an article that do not affect the period numbers; they can be assigned in advance;
    • «Form articles» - cost articles with the «SRC», «PER DAY», «ON» columns; the chevron next to the source expands the article's accounts, the «ON» switch turns the article on and off;
    • «Banquet accounts» - accounts whose write-offs make the «Banquets» row suggest an amount;
    • «Exclusions» - accounts with a reason («account name = reason») and posting types excluded from the consumption method;
    • «Distributing the stock count by day» - «By calendar days» or «Only by working days»;
    • «Surpluses and shortages in the consumption method»;
    • «Rows that show a percentage».
  4. Enter why you are making the change and click «Apply model». Before saving, the two methods are reconciled for months with a stock count; a change after which they diverge is not applied.
  5. At the bottom, «Edit history» - revisions with date and comment.

The company owner changes the model. Others see the section read-only.

Screenshot«Daybook settings», «Articles and sources» section, article table and «Apply model» button highlighted

Upload your own P&L from Excel#

Write rights in «Daily PnL» are required.

  1. In «Articles and sources», click «Upload P&L (Excel)» and choose an .xlsx file.
  2. The system shows the file's sheets (unrecognised ones are struck through) and rows by section: month, row number, bar or kitchen, article, amount from the file, system amount, confidence and a mark («file», «system», «corrected», «already uploaded», «not found»).
  3. Accept rows one by one («Accept», «Reject», «Undo»), by section («Accept all in section») or all at once with «Accept all with 100% confidence (N)».
  4. Click «Enter accepted (N)». Amounts go only into empty articles; what the system calculates is not changed.
  5. The upload appears in «P&L uploads». To undo it - «Roll back».
Screenshot«Upload P&L (Excel)» block after parsing a file, «Accept all with 100% confidence» and «Enter accepted» buttons highlighted

What the numbers mean#

  • The «Day», «Week», «Month» cards - Syrve till revenue for the period the selected day belongs to. «6 of 7» - how many days of the period are already loaded.
  • Cost for a day and a week is calculated by the consumption method, for a month and a year by the stock-count method. On a day and a week the cost row is called «By recipe cards of dishes sold», on a month «Cost by recipe cards».
  • The «Src» column says where the row comes from and whether it is complete: «exact», «estimate», «incomplete», «entered», «no data», «nothing to check with». «no data» - there is no source for the period; such a row is not included in totals.
  • The question mark on «Result» - what has not been entered compared with the previous month.
  • An underlined cost number - a Syrve document edit affected it; the hint says by how much, a click leads to «Edit log».
  • The data moment is in the tile hints: revenue is updated overnight, cost by the saved month recompute.
  • «Goal» and «To goal» (Daybook Pro) - the row's actual against the goals from «Daybook settings» → «Goals and norms».

FAQ#

Why is cost of goods for a day and for a month calculated differently? Day and week use the consumption method: usage by recipe cards of dishes sold plus all write-offs. Month and year use the stock-count method: opening stock + goods received - closing stock - complimentary items - tasting - household expenses. A stock count is done once a month, so at a day boundary there is no counted stock.

What does «the invariant holds» mean? The sum of the month's days by the consumption method must match the month's stock-count cost where a stock count has been done. A difference is not allowed; it is broken down instead: accounts without an article, posting types outside the consumption method, Syrve edits after reading, revaluation of the stock boundary. The unexplained remainder is no more than 0.02 € (two roundings). To check it - the «+ invariant» button in the shield panel.

Why did the two methods diverge? Almost always one of four reasons: a Syrve account is not assigned to an article; Syrve has a posting the consumption method does not see (for example, a cost correction); Syrve changed the month after we read it; the stock boundary is still moving because the next month is open.

What is a cost correction? The warehouse went negative: goods were sold or written off before they were received. There is no price for a negative quantity, so Syrve wrote the goods off at the last known price. When the invoice with the real price arrived, Syrve recalculated the value of what had already been written off and posted the difference to the account «Correction of negative warehouse balances» - as an amount, without quantity. Plus - the goods were written off more expensively than real, usage was overstated; minus - cheaper, usage was understated. It is an adjustment to the value of what was used, not a purchase. The cause is invoices entered into Syrve later than the sale, or not entered. Example: 10 kg sold at zero stock, Syrve wrote it off at 12 €/kg = 120 €. The invoice came at 9 €/kg - correction +30 €, cost of sales is 30 € lower.

Why did last month's cost of goods change? The month was recalculated with fresher Syrve data: the stock keeper corrected the stock count or invoices retroactively, or Syrve revalued the boundary stock while the next month is open. The month's final number comes after the next month is closed. Which documents changed - see the «Edit log» tab.

What does «the stock boundary is still moving» mean? Syrve values the stock on the 1st at average price and keeps recalculating it until the next month is closed. We take a snapshot of the stock overnight and show how much it has shifted (revaluation). The month's number is not final while the boundary is moving.

What does «Syrve changed documents of a closed month» mean? After we read it, a document of a closed month was corrected in Syrve. The shield report names the documents, the number of items and the amount «before - after», and the banner «Syrve document edits in closed <month> without a decision» appears above the report table. The decision is made on the «Edit log» tab: «Accept» - the edit goes into the report (the month is recomputed overnight), «Revert» - the stock keeper gets a task to roll the document back in Syrve.

When is a month considered closed? The closing cycle: 1st - stock count, 5th - data entry and preliminary results, 7th - review, 12th - final results, 15th - report. In the «Edit log» a month counts as closed from the 15th of the following month (chip «closed <date>»), or earlier if closing is confirmed on «Month closing». Edits after that date are marked «after closing» and can be picked out with the «After closing» filter.

Why does our bar revenue not match the accountant's? We split dish revenue by place of preparation - the same way as the Syrve fiscal. The accountant usually splits by product groups. The difference comes from modifiers without their own place (a drink in a set) and items without a place in Syrve.

Where does a modifier without a place of preparation go? By the «Modifier split» setting of its group: «by dish» - to the department of the main dish, like the fiscal; «by departments» - to the department of its own product group. A new group is «by dish». The setting is in «Settings» → «Accounting methodology» → «Company departments». If Syrve sales have no link between the modifier and the dish, the «by dish» option is unavailable.

Why are gift cards not in turnover? Selling a gift card is a prepayment, not revenue. Revenue appears when the card is used to pay for dishes.

What is the «Other» row? Income outside the till. In Syrve such a sale is posted as a 30 % discount; the row is the sum of that discount. The sign is the discount percentage (29.5-30.5 % because of cent rounding), not its name.

Why is the «Banquets» row empty? Banquet revenue is entered by a person. The system only sees the basis - write-offs to banquet accounts - and suggests their sum: the row is highlighted, the amount is in the hint. The write-off amount is the banquet's cost, not its price, and it is not put into revenue. Banquet accounts are set in «Articles and sources» → «Banquet accounts».

What is the company chart of accounts? A company setting in Daybook: which Syrve account goes into which P&L article. It is in «Daybook settings» → «Chart of accounts» and belongs to the Daily PnL (Daybook package), not to «Accounting methodology».

Where does a new company's chart of accounts come from? RestoAudit has a base chart of accounts - a standard article mapping. A company with an accounting system gets the base chart, and its Syrve accounts are assigned to it automatically where the system is certain. The rest of the accounts a person assigns: however accounting in Syrve is set up, the P&L will be in order. A company without an accounting system gets the base chart as is.

What does the banner «Not all Syrve accounts are assigned to P&L articles» mean? For the selected period Syrve has an amount on an account that is not in any article and is not excluded with a reason. The amount of such an account is not matched. «Assign →» opens the «Not assigned: N» window with the account and the suggested article.

Why is an account with no postings not in the banner? The banner shows only what affects the numbers: an account with a 0 amount for the period does not signal. Such accounts are visible in the chart of accounts in the group «No postings in <month>» - they can be assigned in advance.

What happens if a new account is created in Syrve? We do not create accounts; they are created in Syrve. The Syrve account list is loaded every night. A new account gets an article suggestion; a certain one is applied by the system. If an amount went through the account and it is not assigned, it appears in the banner marked «amount not matched».

Where does the article suggestion come from, and what is auto-apply? The suggestion is based on how the same account is mapped at other companies of the group, on the posting type and on the Syrve account type. A certain one (the same at all companies of the group) the system assigns itself and records in the edit history. An uncertain one is marked «(not certain, a person decides)» and waits for a person. Auto-apply is on by default and is turned off with the «Assign certain accounts automatically» switch in «Chart of accounts».

Can an account be excluded from the P&L? Yes, only with a reason: «Exclude» in the «Not assigned» window or the line «account name = reason» in «Exclusions». An exclusion without a reason is not saved, and the account stays in the banner.

Can an account be assigned to expense articles (the lower half of the P&L)? Yes: a Syrve expense account (rent, cleaning supplies, security, etc.) is assigned to an expense plan article with a code (6210 Rent, 6410 Cleaning supplies, paper, gloves, etc.) via «Choose another article». Its amount shows as the «Syrve write-offs» row under the article. Labour articles (6110-6130) come from attendance and rates; the «Salary» account does not belong to them.

What makes up the «Cost by recipe cards» row? The row can be expanded with the arrow: inside is each Syrve account of this article with its amount, and «Syrve cost correction (negative balances)» if there was one. «Goods received for the period» expands the same way. On the «Day» and «Week» horizons this row is called «By recipe cards of dishes sold».

Why are shipments to other restaurants and returns to suppliers not in the banner? They are already taken into account: subtracted from goods received for the period.

Why does our P&L differ from the accountant's Excel? Our calculation matches its own Syrve components to the cent, so when there is a difference, look for an error in the Excel first. Common reasons:

  • in goods received we subtract returns to suppliers and shipments to other restaurants and include transfers between warehouses, the accountant usually does not;
  • invoices in the Excel were taken from Syrve earlier, and Syrve was corrected later;
  • the accountant takes stock on a different date or from a different report;
  • in the Excel numbers are typed in by hand instead of formulas, last month's values are repeated, double counting. Upload the file in «Articles and sources» → «Upload P&L (Excel)»: each row shows the file amount next to the system amount.