TRANSFER SALES DATA FROM EBRIZA INTO AN ACCOUNTING SOFTWARE
Transfer the inputs from Ebriza into the accounting software. | |
From Ebriza | In the accounting software (ex: Charisma, Saga, Ciel, etc) |
Take data from the Stock Management Report (values without VAT) or Monetary Report (values divided on VAT groups) | In the accounting software save only the values for all inputs - class 3
|
Entries made on raw material or goods purchased for resale Warning: You will enter the values in the accounting software after you filter in the downloaded Excel from Ebriza the values that are on raw materials and goods purchased for resale | Are saved in the account - 301 raw materials and 371 goods purchased for resale |
If you make entries in Ebriza for consumables Warning: You will need to manually retrieve from Ebriza the values that are for consumables | Are saved in the account - 302 consumable |
In case you’re saving in Ebriza the inputs for packaging materials Warning: You will need to manually retrieve from Ebriza the values that are for packaging materials | Are saved in the account - 381 packaging materials |
Outputs transfer from Ebriza into the accounting software. | |
In Ebriza | In the accounting software (ex: Charisma, Saga, Ciel, etc) |
Take data from the Stock Management Report (values without VAT) | In the accounting software save only the values for all inputs - class 6 |
Outputs for raw material or goods purchased for resale Warning: You will enter the values in the accounting software after you filter in the downloaded Excel from Ebriza the values that are on raw materials and goods purchased for resale | Are saved in the account 601 - expenses related to raw materials and 607 - expenses related to goods for resale |
If you make entries in Ebriza for consumables Warning: You will need to manually retrieve from Ebriza the values that are for consumables | Are saved in the account 602 - expenses related to consumables |
In case you’re saving in Ebriza the inputs for packaging materials Warning: You will need to manually retrieve from Ebriza the values that are for packaging materials | Are saved in the account - 608 - expenses related to packaging costs |
Transfer sales data form Ebriza into a accounting software. | |
From Ebriza the data is taken from the Monetary Report | In the accounting software save the values - class 7 - in the account 701 - sales of finished good |
A. Transfer the inputs from Ebriza into the accounting software (Saga C was used as an exemple)
EBRIZA:
1. We are making an input in Ebriza on different VAT numbers
Total value of the invoice, VAT included is 376.81 RON
VAT = 57.81 RON
Value without VAT = 319 RON
2. To see the Invoice on separate VAT numbers you have to go to Monetary Report
In Monetary Report you can see both inputs and outputs.
In the input saved before we have 2 products with VAT 9% and 2 products with VAT 19%.
With VAT 9% we have:
28 RON ( value without VAT 9% )
and 2.52 ( VAT value for VAT 9% )
With VAT 19% we have:
291 RON ( value without VAT 19% )
and 55.29 RON ( VAT value for VAT 19% )
SAGA C: The invoice saved in Ebriza has to be saved in Saga C with quantity 1 and invoice value ( value of the raw material and the value for goods for resale ), the average cost is calculated using global - value method, in the Invoice meniu.
Global - value method is applied for the evidence.
The global-value method applies to bookkeeping of goods and packaging at retail outlets (shops, restaurants, buffets, etc).
Because you are keeping the stock quantities in Ebriza, you don’t have to introduce the quantities is the accounting software, only the total of the invoices in the account 371.
The stock reception is made based on Invoice Reception.
B. Transfer the stock outputs from Ebriza into the accounting software
EBRIZA:
We are making a sale from POS.
The sales can be seen in the Reports meniu.
1. Sales report (V2) - The display is based on the selected grouping and measurement, or the selected time interval
2. Monetary Report
On the green line you will find the sales grouped by VAT.
3. Stock management report
They are filled in based on the documents of entry and exit of the goods and packing and the deposit from the sale, and in the value records (kept on the locations in the accounts of the goods and packaging from the accounting) the records are made on the basis of the same documents.
You can download the stock management report in the formats PDF, Excel or CSV.
SAGA C:
The Ebriza outputs are entered into SAGA C with a quantity of 1 and the value of the outputs (the value of the stocks), which you can deduct from the management report.
If you enter weekly, monthly, quarterly, etc. exits in SAGA, you have to select the above mentioned report to be displayed on the desired time interval.
In Ebriza, decrease of the stocks is done automatically in real time on the basis of consumer receipts or receipts.
There is NO need to decrease the stocks in the accounting software again because in Ebriza stocks will be updated after each receipt, so it is not necessary to draw up the consumer bills on the goods / raw materials included in the product receipts.
If the exit is based on an invoice, the client will have an analytical account 4111, after which the receipt is made.
C. Transfer the saless from Ebriza into the accounting software
EBRIZA:
The sales grouped on VAT can be seen in Daily Report (Z Report)
from the cash register or from Monetary Report from Ebriza
Sales Report V2 is not showing the sales based on VAT groups, only based on products, on cash registers, etc.
The relevant document for the sales is the Daily Report issued by the cas register.
SAGA C:
Income / Receipts is also recorded in the Entrance menu item.
If you want the exit document to be the Z Report, select the "B" fiscal code (the documents entered as type B do not appear in the 394 statement), and enter the "Cash" at the customer. This customer will have 5311 on the analytics account because when the exit is made on the basis of the default receipt, it is also collected.
The exists are introduced in the account 701 with the analytics related to each location (bar, kitchen, etc).
In conclusion to keep an accounting using global - value method the documents that you have to make are:
IR - invoice reception, which is made in Ebriza for stock loading and justification
Consumption receipt - made in Ebriza for stock unloading (eg for consumables)
Stock management report - made in Ebriza to see the value of stock outputs made by sales or consumptions receipt
Monetary Report - made in Ebriza for invoices (grouped on each supplier) and sales grouped by VAT (receipt without client, receipt with client and invoices)
Inventory list - made in Ebriza for stock differences
Account list for various operations - made in the accounting software