|
#2
04-13-2004, 05:40 AM
| |||
| |||
 Re: List of Missing checks for year or several months I thought of that but declined to mention it since it is not suitable for spanning arbitrary lengths of time nor report on "just" what the OP was looking for. But, depending on what the requirement is, it is certainly one way to get there. "Russ Paul-Jones" <russpj[at]microsoft.com> wrote in message news:O0bLYWPIEHA.3476[at]TK2MSFTNGP11.phx.gbl... - quote - > The Monthly Report has a "Gaps in Check Sequences" section. It appears in > the middle of the report, more or less. > -Russ Paul-Jones > russpj[at]microsoft.com |
|
#1
04-13-2004, 01:21 AM
| |||
| |||
| Re: List of Missing checks for year or several months The Monthly Report has a "Gaps in Check Sequences" section. It appears in the middle of the report, more or less. -Russ Paul-Jones russpj[at]microsoft.com "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in message news:%23ebRqsJHEHA.2036[at]TK2MSFTNGP12.phx.gbl... - quote - > Great question. Hmmm. (Five minutes later he returns...) Nothing obvious > appears to me. I know how I'd do it--since I don't see an obvious way to get > there in Money--is that I'd pull the transactions for the account into Excel > using MoneyLink. Then I'd sort by number, do some formula/copy/paste special > values/ (repeat) stuff until I had it down to just unique check numbers. > Then I'd do a formula looking for cases where the number is more than the > previous number + 1. > "Gary" <anonymous[at]discussions.microsoft.com> wrote in message > news:166fa01c41c58$02ccea20$a601280a[at]phx.gbl... > > Please tell me how I can run a report that will list only > > the missing checks from the register. Thanks. |
|
04-07-2004, 12:23 PM
| |||
| |||
| Re: List of Missing checks for year or several months Great question. Hmmm. (Five minutes later he returns...) Nothing obvious appears to me. I know how I'd do it--since I don't see an obvious way to get there in Money--is that I'd pull the transactions for the account into Excel using MoneyLink. Then I'd sort by number, do some formula/copy/paste special values/ (repeat) stuff until I had it down to just unique check numbers. Then I'd do a formula looking for cases where the number is more than the previous number + 1. "Gary" <anonymous[at]discussions.microsoft.com> wrote in message news:166fa01c41c58$02ccea20$a601280a[at]phx.gbl... - quote - > Please tell me how I can run a report that will list only > the missing checks from the register. Thanks. |
|
#-1
04-07-2004, 04:23 AM
| |||
| |||
| List of Missing checks for year or several months Please tell me how I can run a report that will list only the missing checks from the register. Thanks. |
| Tags |
| checks, list, missing, months, year |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Money 2004-Print Checks message appears but no checks to print brandy96: Hello. Hope someone can help with this. I am getting the "Print Checks" reminder in Money 2004 but I have no checks to print. How can I get rid of... | Microsoft Money | 1 | 01-28-2004 02:51 AM | |
| Year to year comparison in Money 2003 Iron Flatline: Hello. I can't seem to generate a report that would allow me to do a year by year comparison of income and spending. I'd like to have all my... | Microsoft Money | 1 | 01-22-2004 01:24 AM | |
| flagging duplicate checks and skipped checks tom: Is there any way to get money to flag duplicate checks and skipped check numbers? I can't find anything about this anywhere. Why wouldn't it do... | Microsoft Money | 2 | 01-12-2004 07:12 PM | |
| money 2003-how do u print a list of checks written Dr. Allan Wohl: is there a way to print out a list of the checks that I wrote for the entire year? | Microsoft Money | 1 | 10-29-2003 03:55 PM | |
| Printing Checks - Different style checks for different accounts Mark Savage: I'm having a problem printing checks from Money 2003. I have three accounts that come up in one .mny file. Two of the accounts use 3-on-a-page... | Microsoft Money | 3 | 10-06-2003 12:00 PM | |
| Thread Tools | |
| Display Modes | |
| |
Linear Mode
