Accounting Reports - Oregon Soccer Central



Accounting Reports

How to convert website results into summary statements in Excel.

Please review the Game Reports document for dealing with reports, referee differences and payment adjustments.

Make sure you’ve opened a blank Excel spreadsheet document…

AFTER you have reviewed the game reports and fixed any accounting discrepancies, get your ideal accounting report. Adjust column headers using the check boxes of Accounting search page and experiment with the Sort By sequences and amount of records you want to display. Below is an example showing 25 records with a sort sequence of ‘Referee, Game Date, Game Time.’

[pic]

[pic]

Copy and paste these results into an Excel spreadsheet. Notice that there are 428 results and that we are seeing one page 1 of 18. BEST to do this process with all of the results in your date range so, adjust the accounting search page to SHOW 500 results.

[pic]

Notice you get blue hyper links from the website. Next step is to copy these records from one excel spreadsheet into another. Highlight the records, copy them (ctrl+C) and select PASTE SPECIAL from the Edit Menu – values only – for results in picture below.

[pic]

[pic]

From here: Delete Rows with results (rows 1, 28 and 29) and highlight all results.

[pic]

Go to Data (top menu bar) and select Subtotals, then adjust the drop down menus inside Subtotal selection - for each change in Referee you want a Sum of what’s in the Total column and you want a Summary below.

[pic]

Proper Results:

[pic]

Notice the small 1, 2, 3 on left hand side of report (just to left of column ‘A’ title)

Click on the ‘2’ to get these results:

[pic]

From here you can print a page to hand to your treasurer and mail checks. Tell the referee to review their reports online to get match their check with their games.

Remember – using the UPDATE mode on the Accounting page will allow you to give the accounting records a pay period. Mark all the records as PAID and give them a unique pay period (text box for you to decide… “Sept 06 pay” or “Fall 06 games” or ???)

[pic]

If Excel spreadsheets are not your strong point – or you prefer not to go that route… here is another method for you to produce referee pay statements.

Go to the Accounting – search page. Adjust the report columns to obtain ideal results. Select one referee at a time from your organization (inside Referee drop down list) and print the pop window of their results. Use the print out as a statement and go from there.

[pic]

[pic]

Hope this document has been helpful. Again, by the end of October 2006, we should have a pay report that’ll show Organization address, user address and accounting records as one statement so you can easily write checks and mail everything in window envelope. Thanks.

10/5/2006

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download