Перейти к содержимому
Меню
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Этот вопрос был отмечен
1 Ответить
2089 Представления

I would like to show how I can define and track my revenues and expenses to a quarterly budget.

Аватар
Отменить
Лучший ответ

Create a Customer Invoice representing your Q1 Sales, for example $18,500.

Create a Vendor Bill representing your Q1 Expenses, for example $8,300.

Using the Documents App, create a new Odoo Spreadsheet based on the template provided:


With Q1 data created, your Spreadsheet will look like this:


Now, add Q2 Income (ie: $19,900) and Q2 Expenses (ie: $9,255):


Now, add Q3 Income (ie: $21,032) and Q3 Expenses (ie: $10,000): 


Be sure to understand which of the cells are dynamically generated (Actuals, Perf), and which are updated via this Spreadsheet by the User (Budget).

This template is hard-coded to use two specific Accounts on the Chart, be sure to understand how to create Spreadsheets from PIVOT tables in Odoo, and how FILTERING works:

 


Finally, if you have several Invoices in a particular quarter, you can right click on the total that is being calculated and see the records that are the basis for the calculation:




Resources for learning about Odoo Spreadsheets:

 
 


 
 


 
 

Аватар
Отменить
Related Posts Ответы Просмотры Активность
2
авг. 25
3668
0
мар. 25
1362
1
июл. 24
1627
3
дек. 23
1871
UpLoad Budget Решено
1
мая 23
2587