1-855-BSA-Soft

BS&A Software Blog

Sep
15

The Excel export can be used as an alternative to generating reports through the Report Designer, and is available on most tables. Instead of editing a report and choosing the data fields to include, exporting to Excel allows you to easily select the data to export, and allows you to group and sum fields to see totals. Excel gives you even more flexibility and control over how your data is represented. Reports created using this method can be exported for use in other Building Department databases.

The software manual – located through your Help menu (View Documentation>Manual) – provides an instructional topic on how to export to Excel. This blog article will highlight some of the features.

Tables can be filtered prior to running the export, and edited once you’ve launched the export. Filters are addressed in a previous blog article by Adam Bengal (http://bsasoftware.com/Blog/articleType/ArticleView/articleId/720/Help-with-Filters). Your software manual also provides information on filters.

Titles can be saved/edited for the export:

A large variety of fields are available for selection, and may be ordered for export in any manner you wish (there are rules for ordering fields when exporting for charting purposes; this is addressed in the software manual):

If you choose to Group By a particular field, a summary sheet will be provided along with a sheet for each type. For example, if you “Group By” Permit Type, and four permit types are exported, you will have five sheets: one for each type, and a summary of all:

Field names can be changed to appear less cryptic on the Excel spreadsheet:

Totals can be shown (i.e., total number of permits issued or total amount of permit fees collected):

 

Posted in: Community Development

Views: 6920

Interested in learning more?

Get in touch and we would be happy to schedule a detailed overview of our solutions. 

#17

Why use BS&A Software?

You and your limited staff will not need to keep up with all legislative changes. We are on it. Our ongoing commitment is to keep up with all of the technical and governmental changes that are being thrown your way.

See more reasons

The one feature that has made my life easier is the report profiles. I used to print and email each department’s monthly financials. With BS&A’s General Ledger application, I have preset report parameters for each department. At month end, departments select their preset profile and print their own financials. Specialized departmental report profiles have also been setup under other fund accounting applications (Payroll, Timesheets, Cash Receipts).
Steve Maga, Staff Accountant/Information Systems

Need help finding the right software solution?

We’ll help you find the software that fits your needs. Get in touch with our team to get started.

Get in Touch

Software Support & Training

Your resource for everything you need to learn about your software. Can’t find what you’re looking for? Get in touch for support.

Featured Tutorial

Check out our learning center for more videos
Employee Self Service

Employee Self Service

Employees can view prior checks, request changes to personal employment information, check leave balances, etc.

Added in AccessMyGov

Have questions or want to learn more about our software? We’re here to help! Feel free to

Get in Touch