sm 2012 funds enquiry view the balances on an analysis code filter on combinations export to excel...
TRANSCRIPT
![Page 1: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/1.jpg)
SM 2012
Funds Enquiry
View the balances on an Analysis Code
Filter on Combinations
Export to Excel
Drill Down to Document
![Page 2: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/2.jpg)
SM 2012
Funds Enquiry
View the balances on an Analysis Code
Double Click Funds
![Page 3: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/3.jpg)
SM 2012
1. Select Period Up to2. Select Period range
3. Select Analysis by clicking blue square
to include all years select
“Project to date” but remember to ignore account 03300 as this is reinstated each year and will be
duplicated
See Selection
criteria laterto include current year select “Year
to date” If balance has
been reinstated on account 03300 the analysis code
balance will be correct
![Page 4: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/4.jpg)
SM 2012
i. Project to date selected (to pick up prior years)ii. Period to date
iii. Balancesiv. Total account
If selecting Project to Date you must ignore balances on
account 03300.(see guidance on Opening
Balances)
![Page 5: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/5.jpg)
SM 2012
Note Options
Time Profile
Notes:1. Actual re last year(2008) = (11,200.00)
2. Income this year = (155.72) ------------------ (11355.72)
3. Encumbrance = 4887.50 ------------------
4. Balance = (6468.23)
Car
eful
– n
ot S
tand
ard
Dr/
Cr
Con
vent
ion
(+)
= c
ash
in h
and
for
this
col
umn
only
![Page 6: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/6.jpg)
SM 2012
Be Careful when relying on Funds available figure.
In this example no Income budget has been
enteredTherefore it will allow
£71,200 expenditure + £63,000 Income
![Page 7: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/7.jpg)
SM 2012
Adding an income budget allows the funds enquiry to work
effectively
![Page 8: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/8.jpg)
SM 2012
Funds Enquiry
Filter on Combinations
![Page 9: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/9.jpg)
10-10000-1000000000-82520-10000010-10000-1000000000-82673-10-10000-1000000000-85030-1000010-10000-1000000000-85100-10000010-10000-1000000000-85780-10000010-10000-1000000000-99000-10000010-10000-1000000000-99100-10000010-10000-1000000000-99101-100000
SM 2012
1. Filter on combinations
1.Click on combinations2.Press F11
3.Type in filter4.Press CTRL+F11
![Page 10: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/10.jpg)
SM 2012
Funds Enquiry
File>Export
![Page 11: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/11.jpg)
10-10000-1000000000-82520-10000010-10000-1000000000-82673-10-10000-1000000000-85030-1000010-10000-1000000000-85100-10000010-10000-1000000000-85780-10000010-10000-1000000000-99000-10000010-10000-1000000000-99100-10000010-10000-1000000000-99101-100000
SM 2012
2.File>export
1.Click on combinations2.Click File>Export
3. Follow Instructions
The file has a TSV extensionYou can save this or…
INSRV can set up your computer to open into Excel
![Page 12: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/12.jpg)
SM 2012
Funds Enquiry
Drilldown
![Page 13: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/13.jpg)
SM 2012
Inquiry>FundsSelect periodSelect blue boxInput search criteria
![Page 14: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/14.jpg)
SM 2012
1.Select combination2.Tools>Period Balances
![Page 15: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/15.jpg)
SM 2012
1.Select period2.Tools>Actual Lines (orEncumbrance or budget)
![Page 16: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/16.jpg)
SM 2012
1.Select journal line(can use filter)
2. Click drilldown Button
![Page 17: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/17.jpg)
SM 2012
Click View Transactions
![Page 18: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/18.jpg)
SM 2012
New page opens
![Page 19: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/19.jpg)
SM 2012
1.Click View
Payments
2.Click PaymentsOverview
![Page 20: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/20.jpg)
SM 2012
Click Invoice
Overview
![Page 21: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/21.jpg)
SM 2012
Paperclip is Yellow..Click it
![Page 22: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/22.jpg)
SM 2012
ClickOpen
Document
![Page 23: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/23.jpg)
SM 2012
Finally….
![Page 24: SM 2012 Funds Enquiry View the balances on an Analysis Code Filter on Combinations Export to Excel Drill Down to Document](https://reader035.vdocuments.us/reader035/viewer/2022070306/55161093550346cf6f8b6232/html5/thumbnails/24.jpg)
SM 2012