Business Spreadsheets
Payroll Aliquot Worksheet by Automatic CNAE
​
Entering the company's CNAE in the yellow field, the worksheet already carries all the corresponding payroll aliquots, Sefip codes and activity description.
Very useful when using inquiries and registration of new companies in the system, check tax collection and declarations, it is also interesting for partners who think of changing the activity company and simulate cost changes.
RHLive produces specific spreadsheets for your business.
They are fully automatic spreadsheets, designed to perform calculations, control, conferences and schedules automatically, reducing manual work by your team and eliminating errors.
It allows you to do the same calculation that your system does, running an automatic conference in parallel.
Below we provide some worksheets we have elaborated, very useful among all our clients.
free download below.
DAE Guide Calculation Worksheet - E-Social - Maid
​
Entering the data of the Domestic Maid in the fields in yellow, the worksheet automatically calculates the taxation, simulating the value of the DAE guide generated by the E-Social site.
This is a great tool to check if the value of the AED tab is actually correct.
The worksheet allows you to calculate an Employer's guide with up to 4 employees.
​
JAM Aliquot Update Worksheet - FGTS Extract Simulation
​
The JAM Aliquot Update Worksheet simulates the value of the FGTS Statement generated by Social Connectivity.
This worksheet is very useful for cases where there are open FGTS deposits, but it is necessary to know the full amount to calculate the GRRF.
It is also widely used when the access to the internet is unavailble.
By filling only the competence and the value of the deposit, the worksheet calculates the JAM update automatically.
Food Pension Looping Worksheet
​
The Food Pension Looping Worksheet automatically calculates the Alimony Pension in cases where there is an Income Tax amount to be deducted from the pension calculation, and there is a pension amount to be deducted from the IR calculation, thus causing a calculation to Loop.
Retirement Calculation Worksheet - By Time and Age
​
The Retirement Calculation Worksheet automatically calculates the most viable retirement by comparing time and age, bringing the average retirement value and simulating the date of your retirement.
It is worth checking because it brings a sense of time, values an contributions, enabling the planning of retirement.
Ask us to develop a customized spreadsheet.