Viewing Interest Detail in Excel

BA Icon

Viewing Interest Detail in Excel

 

Brief Accounting has the option to print Accounts Receivable Statements to file, which can be opened with Excel. This allows you to view the amount of interest accrued at whatever date you choose.

 

Choose the A/R module > Statement tab and pull up the matter in question

From the O/S sidetab click Print

Check Statement of Account

Select Print to File

Screen_shot_2010-09-23_at_11.04.32_AM.png

 

Hit "Print"

An XLS file will be created.

 

Now open the file using Excel. It shows you the interest total in column N.

You can change the date in cell N4 to see what the interest would be as at different dates:

 

Screen_shot_2010-09-23_at_11.06.25_AM.png

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk