--- title: "Billing Preparation" slug: "billing-preparation" updated: 2022-09-13T03:39:09Z published: 2022-09-13T03:39:09Z canonical: "docs.corporatecu.com/billing-preparation" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.corporatecu.com/llms.txt > Use this file to discover all available pages before exploring further. # Billing Preparation This [function](https://cccuplatform.z14.web.core.windows.net/billing/billing-preparation) represents the screens and utilities required to enter and maintain member transactions and charges for the fiscal period. These billing record transactions will be used to create member invoices for the fiscal period. ### **Billing Record Main Page** **![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1646260012846.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=%2BwKCpYL2RZw14YsloevWcF0vc68irKvNZS20BufJfDc%3D)** When coming into this screen, the system will default the date to the current fiscal month. The rules on these screens are as follows: - A closed fiscal month will show the transactions, but no editing is allowed. - The current fiscal month is open to entering and maintaining transactions up to the point that invoices are finalized through the month end process. After that point, no editing is allowed. - Future fiscal months are open to entering and maintaining transactions. These billing preparation screens present the transactions structured as follows: ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1646255456766.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=SOcKTk8hGuaSRMJL4WUjPoSiA2QhgTFRjVVwNJr8xiw%3D) The first page of the Billing Preparation page brings up the list of items being charged in the fiscal period with some calculated totals, including a difference percentage between the selected fiscal period and the previous fiscal period. #### **Missing Transactions indicator** On this screen, there is a “Missing Transactions” indicator that will identify any product lines that have no charges for the selected fiscal month. This is meant to be a warning that data has not been loaded yet, but this will not prevent any actions in the system. ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/billing-preparation-image-0p6e1i74.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=w9E7DOn7Vh9jivVJrDptV%2FXcNvM8j2Cty4%2FkgjoG7HU%3D) The example screen shown above depicts the pop-up when the button is clicked. This gives the user an opportunity to review the missing transactions and choose to ignore the warning this month if no transactions are expected. #### **Add Records** Adding Records to the billing transaction screen will allow you to add a new product record/item to the fiscal month. You can only add the product record IF it does not already exist in the fiscal period. ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/billing-preparation-image-v09ux6zf.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=GSJSqp3JHWjPpVyw9ADxGv44vAbnd%2B9FyrTydJrgkVk%3D) Multiple selections can be “selected” and then clicking the “Add” button will add the new product record lines to the fiscal month. Once the new product record lines are added, each line can be maintained by clicking on the link on the “Product” field of the record. This will direct you to the Billing Preparation Detail page. ### **Billing Record Detail Page** By clicking on a Product link from the Billing Preparation Main Page, you will be directed to the details of the Billing Record. ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1659198794446.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=kI9U1WqZ3pi5zILRsAZYD87BIshMM%2B1mePmVRiXJsd8%3D) This screen shows the details of the Billing Record, including the comparison between the previous month’s total price versus the selected fiscal month’s charge. Using this screen, the transactions for a member for this particular product record/item can be maintained. The editable information would be the following: - Member Name – Required - Site Name – Editable - Optional (used for specific services i.e. Corporate Cash, ATM) - Recurring – Editable - Indicates if this was added via a Recurring rule - Quantity – Editable - Required - Price – Editable – allows the user to override the system calculated unit price - Extended Price – Read Only – Calculated After making any changes, click the “Save Changes” button. **Note**: When a fiscal period is closed or when the current fiscal period invoices have been finalized, there is no longer any editing allowed on the billing item transactions. ### **Process Data - Uploading Billing Information** Process Data refers to uploading data to the Beastro Billing system for the selected fiscal month. This data processing does require some pre-work steps as detailed below. #### **Process Data - Prework** The Beastro Billing system is setup to look to the document library Billing directory for the files to process. Users will need to prepare the required files and then upload those files to the document library. Once the files exist in the document library, the “Process Data” wizard can be run within Beastro. As a final step in that process, the files that are processed will be automatically moved to a month-dated archive folder in document library. This way the original imports are not lost or staying in the document library processing directory. #### **Process Data Wizard** From the main page, the Process Data wizard can be started by clicking the button. Note that the wizard will set the fiscal month to the month you have selected on the Billing Preparation main screen. This does allow you to upload data for future months if you choose a future month for the fiscal period. This wizard consists of six steps: ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1646325089714.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=jWHvFszD4ILEH7sMSggxXsYlVY7vdK23drNKKjBHNmg%3D) - **Select Data Source** – shows the files in the document library directory to be processed - **Setup Member Linkage** – identifies if there are member ids from a vendor that need to be matched to a Corporate Member. This also will be used if a Vendor’s member site ID needs to be linked a Corporate Member Site (Corporate Cash). - **Setup Record Linkage** – identifies if there are item IDs from a vendor that need to be matched to a Corporate product. This is also used to identify what vendor items should be ignored. - **Verify Data Source** – see raw data summary, resolve errors, and “existing item handling” - **Prompt for Price Record** – provide the product unit price if the item is a “prompt for price” product. - **Final Review** – preview summary of the pricing and cost data for the file that will be loaded to the Billing Preparation screen. ##### **1. Select Data Source** The first step of the wizard will display all the files that exist in the document library. ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1646325527038.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=Piosc1wuh%2FAqpXmpUU7ybqZ1bdW41xyou%2Fr3oVwCg6w%3D) Each file to be processed must specify the “Template” used for processing the file. A template defines how the file is formatted and other information about the file, such as the vendor providing the data. A Template can be selected for the file by using the drop down on the Template row. Multiple files can be assigned to the same template by selecting the files with the checkbox and then choosing the “Apply Template” button in the upper right corner of the screen. Once a template is applied, the file is ready to be processed. Multiple files can be processed at the same time by selecting those files. Click on the “Next Step” to load the file(s) into the system. ##### 2. **Setup Member Linkage** ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1657280477855.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=gz3TqeEpSK8QEHC977Cy7oIULa9c1BS0GKJgGpoaDwk%3D) For vendor files, if the system cannot determine the Corporate Member or Member Site based on the vendor’s member identifier information, this screen will prompt the user to choose the member or member site. The “Partner Member Name” and/or “Partner Member ID” will show the information the vendor has provided to identify the member or member site. Clicking the down arrow on the row will show the product records from the file that are using this “Partner Member Name” or “Partner Member ID”. This is all information to help you identify the correct member or member site. To continue to the next step, any records that need a linkage must have the member or member site set. Once this is setup in the system, future files from this vendor will use that member for the provided identifier. **3. Setup Record Linkage** **![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1663039665893.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=JxKpBcyWjQQTNYrSg1F7izO4tdByC35ZmDBbmicO3PQ%3D)**For vendor files, if the system cannot determine the Corporate Product based on the vendor’s product/item identifier information, this screen will prompt the user to choose the product. The “Partner Record Code” and/or “Partner Record Description” will show the information the vendor has provided to identify the product. Clicking the down arrow on the row will show the member records from the file that are being charged for this “Partner Record Code” or “Partner Record Description”. This is all information to help you identify the Corporate product. Another option on this screen is to just ignore the vendor’s “Partner Record Code/Description”. When this is ignored, then data from those records will not be imported to the Billing Preparation area from this file. For every file that is processed, if there are vendor “Partner Record Code/Descriptions” that are ignored, they are brought up in this screen for review. This allows you to un-ignore a product record if the corporate credit union begins to charge members for that item. To continue to the next step, any records that need a linkage must have the Corporate Record set OR have that vendor product marked as an Ignore. Once this is setup in the system, future files from this vendor will either use that record for the provided identifier or ignore the record. ##### **4. Verify Data Source** ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1663039743938.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=8dG6HeXzXqmrIKcsaHTQARTylKNN8pBz%2FU9Mu6Rs%2FQg%3D) This step of the wizard provides information about the imported files. At this point in the wizard, this is just showing raw data information without applying discounts or adjustments. The main purpose of this step is the following: - Review summary numbers and file status. - Resolve errors with the import. - Adjust any settings on handling existing records. The above screen shows summary information in the top area. By clicking the down arrow on the file, you can get to the detail screen to show the file details as shown here: ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1663039865250.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=GQpCw%2Fcz65kNCKMJ1JmGjbj%2F%2BZdaLln4oNNBIP6lhlQ%3D) ###### **Error Resolution** Error resolution needs to occur before you can proceed to the next step. The summary screen will show you how many errors have been encountered. Clicking the error message itself will allow you to navigate to the “Error Items” tab and view the errors. Each error allows an action for resolution of the error. In most cases, an “Error Resolution Note” is required to be entered. Here is the list of errors and actions that can be taken. | **Template** | **Error** | **Row or File Error** | **Actions (choose one)** | Comment | | --- | --- | --- | --- | --- | | Vendor A | ATM Service costs do not match | Row | 1) Acknowledge and move on | **Acknowledge** requires the filling in of the Resolution Note | | Vendor A | Mismatch of Service Frequency | Row | 1) Acknowledge and move on | | Vendor A | Excess Item costs do not match | Row | 1) Acknowledge and move on | | Vendor A | Excess Liability costs do not match | Row | 1) Acknowledge and move on | | Vendor A | Excess Item Total above Threshold | File | 1) Acknowledge and move on 2) Charge Item to all affected customers | | Vendor A | Excess Liability Total above Threshold | File | 1) Acknowledge and move on 2) Charge Item to all affected customers | | Multiple | Quantity is not valid (bad data) | Row | 1) Quit, fix spreadsheet and re-import | | | Multiple | Total Charge is not valid (bad data) | Row | 1) Quit, fix spreadsheet and re-import | | | Multiple | Vendor Cost is not valid (bad data) | Row | 1) Quit, fix spreadsheet and re-import | | | Standard Billing | Product Record (item) does not exist | Row | 1) Choose Item 2) Quit, fix spreadsheet and re-import | Fix Record | | Standard Billing | Member Routing Number is not valid | Row | 1) Choose Member 2) Quit, fix spreadsheet and re-import | Fix Record | | Standard Billing | Member Site Number is not valid | Row | 1) Choose Member Site 2) Quit, fix spreadsheet and re-import | Fix Record | | Standard Billing | Quantity is not valid | Row | 1) Update Quantity 2) Quit, fix spreadsheet and re-import | Fix Record | | Multiple | No price exists for this item | Row | 1) Quit import, ask Cherie or Linda to set price on item, re-import | | ###### **Existing Item Handling** If a file is imported more than one time with the same data or someone manually added Billing Item transaction information for a member and the imported file contains more charges for that member and product, this produces an “Existing Item” affect. Beastro allows you to select what to do for those items found that already exist. The options are: - Replace – completely replace any existing data for this fiscal period, member, and product with the information coming in with the file. For vendor files, this is the default. - Append – Add the new information from this file to the existing information for this fiscal month, member, and product. This is the default for the Standard Billing Template. The Existing Items screen will show what the system has set to do for those items with existing data. You can change these options in this screen, but it is not required to do so. ##### **5. Prompt for Price Record** This step will prompt the user for the member’s unit price for any corporate products that are setup as a “Prompt for Price” product. To continue to the next step, provide a unit price for the member for this product. ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1663040130711.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=65w3c%2BLfYEMyYMioyFTPza0qWDDdL8ialjHGLEHrVPA%3D) ##### **6. Final Review** At this stage, the data is ready to be loaded into the Billing Preparation screen. This is a final review of the data, by member, with discounts, adjustments, and sales tax applied for this file’s information. ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/image-1663040320125.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=NG12%2ButcjVIL1vRBwcgXAMnIBryfRAyLRV8hKKvq%2F70%3D)There is a difference between Vendor uploaded files and the Standard Billing Template. Standard Billing Templates do not include any costs analysis, so the views are slightly different. Clicking into a file will show the summary by member. On any member, you can click the “View Details” link to view the member’s detailed information. When the review is complete, clicking the “Complete” button will load this data into the Billing Preparation screen for the selected fiscal month. ![](https://cdn.document360.io/79b73003-772f-429b-afdd-b7e377cc9b05/Images/Documentation/billing-preparation-image-lmljrulo.png?sv=2026-02-06&spr=https&st=2026-11-20T21%3A17%3A37Z&se=2026-11-20T22%3A17%3A37Z&sr=b&sp=r&sig=TmMDsoOepxnsY7YBxqtrgy2wSLs5A6oNeUnMaD2JXjA%3D) The information can now be viewed and modified as required within the Billing Preparation screen prior to invoices being finalized during the Month End process.