# \#register **URL:** https://community.silverfin.com/tag/register/397.md [Latest](https://community.silverfin.com/latest.md) · [Categories](https://community.silverfin.com/categories.md) · [Tags](https://community.silverfin.com/tags.md) --- ## [Reconcile against the Fixed Asset Register](https://community.silverfin.com/t/reconcile-against-the-fixed-asset-register/2364)
**Author:** [@rory.grant](https://community.silverfin.com/u/rory.grant)\ **Replies:** 2\ **Last updated:** [November 22, 2022, 2:15pm UTC](https://community.silverfin.com/t/reconcile-against-the-fixed-asset-register/2364 "2022-11-22T14:15:12Z")
Hi, we have a template which we created which we reconcile against the Fixed Asset Register. Since the updates to the Fixed Asset Register last month it no longer reconciles. It would appear that this relates to the foll… --- ## [Eigen Vermogen - hide detail](https://community.silverfin.com/t/eigen-vermogen-hide-detail/1426)
**Author:** [@cedric.devos](https://community.silverfin.com/u/cedric.devos)\ **Replies:** 1\ **Last updated:** [March 11, 2019, 2:30pm UTC](https://community.silverfin.com/t/eigen-vermogen-hide-detail/1426 "2019-03-11T14:30:18Z")
Hi there, I made a copy of the Silverfintemplate ‘Eigen vermogen’ because I didn’t want a detail of all the transactions of the Equity in the export so I inserted {% ic % } and {% endic %} a few times. When I export t… --- ## [Stop information being carried forward to next section](https://community.silverfin.com/t/stop-information-being-carried-forward-to-next-section/1381)
**Author:** [@neilmiller](https://community.silverfin.com/u/neilmiller)\ **Replies:** 11\ **Last updated:** [February 14, 2019, 9:19am UTC](https://community.silverfin.com/t/stop-information-being-carried-forward-to-next-section/1381 "2019-02-14T09:19:58Z")
Hi, I have the below coding for a stock rec I am working on. I am hoping to have the stock sheet in sections, e.g. Raw Materials, Cattle, Pigs (we deal with agricultural clients). I like the layout I have set up but am n… --- ## [Template "holiday pay"](https://community.silverfin.com/t/template-holiday-pay/1373)
**Author:** [@Yana](https://community.silverfin.com/u/Yana)\ **Replies:** 1\ **Last updated:** [February 5, 2019, 3:46pm UTC](https://community.silverfin.com/t/template-holiday-pay/1373 "2019-02-05T15:46:44Z")
Hi there I’ve tried to create a template for provision holiday pay. See my code below. I’ve tried this in an file but I don’t get an green sphere when it’s reconciled. "{% stripnewlines %} |Omschrijving |Bezoldigin… --- ## [Using a total of a Column as part of a calculation in a row](https://community.silverfin.com/t/using-a-total-of-a-column-as-part-of-a-calculation-in-a-row/1351)
**Author:** [@AlexanderDB](https://community.silverfin.com/u/AlexanderDB)\ **Replies:** 2\ **Last updated:** [January 14, 2019, 4:48pm UTC](https://community.silverfin.com/t/using-a-total-of-a-column-as-part-of-a-calculation-in-a-row/1351 "2019-01-14T16:48:32Z")
Hi, I’m trying to make a calculation as follows: In cell in column “Herkwalificatie” "value in “in aanmerking te nemen leningen”/ “Totaal in aanmerking te nemen leningen” \* “Totaal Max. R/C” \* “Rentetarief” for exam… --- ## [Calculating with ratios of the previous year](https://community.silverfin.com/t/calculating-with-ratios-of-the-previous-year/1350)
**Author:** [@cedric.devos](https://community.silverfin.com/u/cedric.devos)\ **Replies:** 2\ **Last updated:** [January 14, 2019, 9:37am UTC](https://community.silverfin.com/t/calculating-with-ratios-of-the-previous-year/1350 "2019-01-14T09:37:42Z")
Hi there, I’m building a template where I need to show the ratios of the current and the previous year. Calculating the ratios of the current year doesn’t give any problems, but I don’t know how to obtain the data of t… --- ## [Make a total in table 2 based on info in table 1](https://community.silverfin.com/t/make-a-total-in-table-2-based-on-info-in-table-1/1346)
**Author:** [@sylvia.debaeremaeker](https://community.silverfin.com/u/sylvia.debaeremaeker)\ **Replies:** 1\ **Last updated:** [January 10, 2019, 10:19am UTC](https://community.silverfin.com/t/make-a-total-in-table-2-based-on-info-in-table-1/1346 "2019-01-10T10:19:30Z")
In table 2 , I want to make the total of the amounts, based on the % filled in in table 1. I’ve tried with if-statements, but this is not working. Table 1: Blockquote {% fori detail in custom.dividenden %} {% newli… --- ## [How to make a total when there are different ranges to consider?](https://community.silverfin.com/t/how-to-make-a-total-when-there-are-different-ranges-to-consider/1333)
**Author:** [@sylvia.debaeremaeker](https://community.silverfin.com/u/sylvia.debaeremaeker)\ **Replies:** 7\ **Last updated:** [January 8, 2019, 1:34pm UTC](https://community.silverfin.com/t/how-to-make-a-total-when-there-are-different-ranges-to-consider/1333 "2019-01-08T13:34:50Z")
How can the following situation be programmed: There is a total amount of f.i. 75 000 or 25 000 For the maximum amount of 59 970: a. for 0-15990: 50% may be deducted b. for 15990-31990: 25% may be deducted c. for 31… --- ## [Calculation percentage in table](https://community.silverfin.com/t/calculation-percentage-in-table/1332)
**Author:** [@sylvia.debaeremaeker](https://community.silverfin.com/u/sylvia.debaeremaeker)\ **Replies:** 11\ **Last updated:** [January 4, 2019, 12:50pm UTC](https://community.silverfin.com/t/calculation-percentage-in-table/1332 "2019-01-04T12:50:30Z")
The percentage calculated is added up instead of calculated for each line separately. {% newline %} |Naam |Bruto auteursrecht |% RV |Bedrag RV |% RV |Bedrag RV {% newline %} |-----30%----- |----20%----: |—10… --- ## [How to make totals of results?ma](https://community.silverfin.com/t/how-to-make-totals-of-results-ma/1331)
**Author:** [@sylvia.debaeremaeker](https://community.silverfin.com/u/sylvia.debaeremaeker)\ **Replies:** 1\ **Last updated:** [December 28, 2018, 1:06pm UTC](https://community.silverfin.com/t/how-to-make-totals-of-results-ma/1331 "2018-12-28T13:06:39Z")
I want to make the total of f.i. R54 + R61 + R63. How can i do that? | {% t “Totaal” %} |{{$1|currency}}{% result ‘R59’ $1 %}|{{$2|currency}}{% result ‘R62’ $2 %}|{{$3|currency}}{% result ‘R64’ $3 %}|{{$4|currency}}{% … --- ## [Link existing template to new report](https://community.silverfin.com/t/link-existing-template-to-new-report/558)
**Author:** [@Dons](https://community.silverfin.com/u/Dons)\ **Replies:** 15\ **Last updated:** [November 5, 2018, 1:02pm UTC](https://community.silverfin.com/t/link-existing-template-to-new-report/558 "2018-11-05T13:02:12Z")
Hi I would like to link the template verworpen uitgaven to my report. I added already a handle verworpen\_uitgaven. What do i need to use as formula in my report? F.ex. category in my template verworpen uitgaven is ge… --- ## [Name a place in a template](https://community.silverfin.com/t/name-a-place-in-a-template/1260)
**Author:** [@Joyce\_Olivier](https://community.silverfin.com/u/Joyce_Olivier)\ **Replies:** 3\ **Last updated:** [October 29, 2018, 4:51pm UTC](https://community.silverfin.com/t/name-a-place-in-a-template/1260 "2018-10-29T16:51:58Z")
Hello, i want to give a name to a place in my report , so i can use this one in another report. this is the code from my report "beroepskosten) {% for cost\_category in cost\_categories %}{% assign $11 = 0 %}{% assign $1… --- ## [Details do not export](https://community.silverfin.com/t/details-do-not-export/1023)
**Author:** [@Julie\_Vandekerckhove](https://community.silverfin.com/u/Julie_Vandekerckhove)\ **Replies:** 7\ **Last updated:** [August 21, 2018, 1:10pm UTC](https://community.silverfin.com/t/details-do-not-export/1023 "2018-08-21T13:10:25Z")
Hi I made an overview per year of all the investments per categorie / account. But when I export not all the lines get exported… I figured out that details with a date previous to “end first bookyear” do not export bu… --- ## [Questions: Table not being shown; Accounts not selecting from CY information](https://community.silverfin.com/t/questions-table-not-being-shown-accounts-not-selecting-from-cy-information/1124)
**Author:** [@ThomasB](https://community.silverfin.com/u/ThomasB)\ **Replies:** 3\ **Last updated:** [August 16, 2018, 6:48pm UTC](https://community.silverfin.com/t/questions-table-not-being-shown-accounts-not-selecting-from-cy-information/1124 "2018-08-16T18:48:14Z")
Hi there Just recently started using Liquid/Markup, and have 3 questions from the same coding: When creating tables, sometimes it works, sometimes it doesn’t show as a table correctly (see below) This is not pic… --- ## [Unwanted accumulation - register madness](https://community.silverfin.com/t/unwanted-accumulation-register-madness/1041)
**Author:** [@twynant](https://community.silverfin.com/u/twynant)\ **Replies:** 3\ **Last updated:** [July 9, 2018, 8:29pm UTC](https://community.silverfin.com/t/unwanted-accumulation-register-madness/1041 "2018-07-09T20:29:15Z")
Hi, Would like to have your assistance on this one. I’ve already searched other topics on registers but can’t seem to wrap my head around this one. The last column of this template is the difference between column 4 an… --- ## [How to capture a result of a forecast for use in another formula](https://community.silverfin.com/t/how-to-capture-a-result-of-a-forecast-for-use-in-another-formula/1037)
**Author:** [@NickS](https://community.silverfin.com/u/NickS)\ **Replies:** 2\ **Last updated:** [July 5, 2018, 8:22am UTC](https://community.silverfin.com/t/how-to-capture-a-result-of-a-forecast-for-use-in-another-formula/1037 "2018-07-05T08:22:15Z")
Hi @Sam I want to use the Net Revenue result of the year 2020 in a different formula. ( see example on the print screen). I have tried several things including assign and capture but it does not work. Do you know a wa… --- ## [Show number without decimals](https://community.silverfin.com/t/show-number-without-decimals/974)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 2\ **Last updated:** [June 7, 2018, 1:50pm UTC](https://community.silverfin.com/t/show-number-without-decimals/974 "2018-06-07T13:50:22Z")
Hi, I’ve been counting with a register. Although all the numbers that have been added, have no decimals, the register is always shown with .0. What is the easiest way to not show the decimal (as I’m counting with the am… --- ## [Social contributions yearly borders](https://community.silverfin.com/t/social-contributions-yearly-borders/961)
**Author:** [@StagiairAMG](https://community.silverfin.com/u/StagiairAMG)\ **Replies:** 7\ **Last updated:** [June 6, 2018, 9:38am UTC](https://community.silverfin.com/t/social-contributions-yearly-borders/961 "2018-06-06T09:38:38Z")
Hello I have made a template for the yearly revision of the social contributions. However the numbers in the table need to be adjusted yearly to the new boundaries. Is it possible to do this without losing the numbers … --- ## [Unkwown tag in reconciliation](https://community.silverfin.com/t/unkwown-tag-in-reconciliation/965)
**Author:** [@Andrew](https://community.silverfin.com/u/Andrew)\ **Replies:** 1\ **Last updated:** [June 6, 2018, 9:27am UTC](https://community.silverfin.com/t/unkwown-tag-in-reconciliation/965 "2018-06-06T09:27:05Z")
@sven Hey Sven, in my beroepskosten zelfstandigen i want to create a new block to detail my omzet/ontvangsten. Herefore i duplicated the block of my andere bedrijfsopbrengsten, because I think this is simular in creati… --- ## [Beroepskosten - totals](https://community.silverfin.com/t/beroepskosten-totals/952)
**Author:** [@CedricDeVos](https://community.silverfin.com/u/CedricDeVos)\ **Replies:** 7\ **Last updated:** [June 6, 2018, 7:02am UTC](https://community.silverfin.com/t/beroepskosten-totals/952 "2018-06-06T07:02:41Z")
Hi there, In the past totals were shown in the middle colums of the template ‘Beroepskosten’. I just can’t figure out how to get them back. Can someone help me? Thanks in advance, Cedric --- ## [Beroepskosten - reconciliation](https://community.silverfin.com/t/beroepskosten-reconciliation/728)
**Author:** [@Andrew](https://community.silverfin.com/u/Andrew)\ **Replies:** 40\ **Last updated:** [May 29, 2018, 1:19pm UTC](https://community.silverfin.com/t/beroepskosten-reconciliation/728 "2018-05-29T13:19:22Z")
@sven Question… In one of our reports we are using following formula - see below… This gives the total of the ‘rubriek huur’ we are using in other reconciliation. If we want the total of the sum of ‘totale beperking… --- ## [Question with regard to registers and summaries](https://community.silverfin.com/t/question-with-regard-to-registers-and-summaries/796)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 1\ **Last updated:** [April 3, 2018, 1:10pm UTC](https://community.silverfin.com/t/question-with-regard-to-registers-and-summaries/796 "2018-04-03T13:10:07Z")
Hey, For a given template, I have calculated some intermediate results (details) by means of registers. At the bottom of the document, there’s a summary table (one record per detail) that gives a general overview of the… --- ## [Accordance wages](https://community.silverfin.com/t/accordance-wages/760)
**Author:** [@CedricDeVos](https://community.silverfin.com/u/CedricDeVos)\ **Replies:** 1\ **Last updated:** [March 22, 2018, 2:25pm UTC](https://community.silverfin.com/t/accordance-wages/760 "2018-03-22T14:25:49Z")
Hey there, I was thinking of making extra totals under every column for fiscal years not ending at 31/12 (see red mark). I’ve searched in the code but I don’t have a clue. Anyone that can help? Thanks in advance! --- ## [Calculating with registers (amount of shares)](https://community.silverfin.com/t/calculating-with-registers-amount-of-shares/553)
**Author:** [@b.dalle](https://community.silverfin.com/u/b.dalle)\ **Replies:** 4\ **Last updated:** [December 27, 2017, 9:29am UTC](https://community.silverfin.com/t/calculating-with-registers-amount-of-shares/553 "2017-12-27T09:29:46Z")
In a text i’m creating for ‘Notulen’ Im trying to calculate an amount in combination with the total amount of shares by using registers. However, I can’t seem to find an easy way to solve this. So what I’ve done is usin… --- ## [Making totals with registers](https://community.silverfin.com/t/making-totals-with-registers/552)
**Author:** [@Cedric](https://community.silverfin.com/u/Cedric)\ **Replies:** 9\ **Last updated:** [December 21, 2017, 3:59pm UTC](https://community.silverfin.com/t/making-totals-with-registers/552 "2017-12-21T15:59:26Z")
I’m trying to put a total in the first row of a table, the following rows the data needs to be put in. But it seems like it isn’t possible, am I right? I used following code. {{header}}{% newline %} |Voorafbetaling aa… --- ## [Making totals with multiple foriloops](https://community.silverfin.com/t/making-totals-with-multiple-foriloops/522)
**Author:** [@Thijs](https://community.silverfin.com/u/Thijs)\ **Replies:** 2\ **Last updated:** [December 5, 2017, 9:38am UTC](https://community.silverfin.com/t/making-totals-with-multiple-foriloops/522 "2017-12-05T09:38:20Z")
How can I make a total of wederbelegging.bedrag? When I use registers, the totals appears also in the next (first) foriloop. Code: {% fori meerwaarde in custom.meerwaardes %} |\*\*{% input meerwaarde.omschrijving %}\*\*||\<… --- ## [Calculating with dates 2.0](https://community.silverfin.com/t/calculating-with-dates-2-0/386)
**Author:** [@Matthijs](https://community.silverfin.com/u/Matthijs)\ **Replies:** 3\ **Last updated:** [September 6, 2017, 3:12pm UTC](https://community.silverfin.com/t/calculating-with-dates-2-0/386 "2017-09-06T15:12:57Z")
How can i make a difference between two dates that’s being inputted. {%=$1+input custom.dieselpw.begindatum as:date %} {%=$2+input custom.dieselpw.einddatum as:date %} i want to have the amount of days between $1 and … --- ## [Urgent : Adapting Jaarverslag \> P&L not correct anymore](https://community.silverfin.com/t/urgent-adapting-jaarverslag-p-l-not-correct-anymore/333)
**Author:** [@Sven.G](https://community.silverfin.com/u/Sven.G)\ **Replies:** 5\ **Last updated:** [July 5, 2017, 6:51am UTC](https://community.silverfin.com/t/urgent-adapting-jaarverslag-p-l-not-correct-anymore/333 "2017-07-05T06:51:36Z")
Dear All, I’ve changed the “Jaarverslag” by replacing the "Resultatenrekening’ below the ‘balans’. Now I get other totals. If I place the ‘Resultatenrekening’ on top of the ‘Balans’, the totals are correct. I dont un…