Bank Transfers

[paygirl123]

Can I run a report to extrapolate only my bank transfers?

 

[LyleU]

You want to estimate future bank transfers based on existing transfers?

Please explain what you want in more detail.

Lyle

 

[paygirl123]

I often move (or borrow) money back and forth between several bank accounts using the "Bank Tranfers" function under the "Financials" tab. I am wondering if I can run a report that would show only "Bank Transfer Entry" so I can review if I have returned all the monies I have moved throughout the course of the year to the right bank account. (an possibly project the neccessity of future borrowings by looking at past trends)

I could run a reports of the G/L account for a particular bank account but it would show ALL transactions relating to that banks account (checks, withdrawals, deposits, transfers, etc) so I am wondering if I could filter a report like that further by only showing bank transfers.

 

[LyleU]

You can get close with the canned reports that are available in the system. Navigate to Reports > Financial > Bank History. In the Report Option, you can select to restrict the report to just Transfers, and you can restrict the Checkbook ID to just those you are after, either by using a range of ID's or by running a report for each checkbook separately.

Your biggest issue is that the report will show everything since you began using the system or that you have history for. The only way to pare it down, to say a current year, would be to add a date restriction to the report via Report Writer. Any time you want to change the date range, you would need to go into Report Writer and change the date restriction, conceivably once a year when you move to a new fiscal year.

If it was me, I would also modify the report to include a total for each Bank.

Seems to me that these modifications would not be a huge undertaking to set up.

Lyle

 

[LyleU]

OK, I did a little more poking around in the reports and there is another report that will get you even closer.

Navigate to Reports > Financial > Checkbook. Pick the Checkbook Register and set your restrictions for Type, Checkbook ID, and Date as you require.

It appears that this report is hard-coded to only look at the current year so if you need historical information, my first response will give you the best result. Again, I would modify the report slightly to give the users some totals in the footer.

Lyle